vba code for iterating through colums

Private Sub CommandButton1_Click()
CalculateAndDispalyDifference
End Sub

Sub CalculateAndDispalyDifference()
Dim t1, t2 As Date

For counter = 2 To 91
t1 = Worksheets("Sheet1").Cells(counter, 4).Value
t2 = Worksheets("Sheet1").Cells(counter + 1, 4).Value
If t2 > t1 Then
Worksheets("Sheet1").Cells(counter, 6).Value = t2 - t1
Else
Worksheets("Sheet1").Cells(counter, 6).Value = t1 - t2
End If
counter = counter + 1
Next counter

End Sub

Comments

Post a Comment

Popular posts from this blog

Long running Java process resource consumption monitoring , leak detection and GC tuning

For easily monitoring the JVM metrics there is no better tool than Java VisualVM or its older counterpart JConsole; These two tools comes with the Java JDK. So it is absolutely necessary that you copy a JDK version to some temp directory in which your server runs. {Make sure that you do not install the JDK / put the java executable in the path.} Before going in JVM monitoring, it is essential to understand a little about Java's memory model. Note - This article is written with  HotSpot JVM in mind,which is one of the most commonly used one ; implemented by OpenJDK and Oracle - formerly from Sun. This is not the only one , notable being JRockit and others ; and some details would change with a different JVM. When you are running a Java Process in a Server you allocate the Memory for the Java Virtual Machine. This memory is split to process heap { what you give withe the Xmx Xms command}where it is again subdivided on generational basis (Young, Old)  and the PermGen - whic
Read more

Best practises - Selenium WebDriver/ Java

Intermittent failure in Selenium Test cases ? After clicking the drill down sometimes web-elements are not found causing all summary table test cases to fail. Common Root Causes 1)  Prefer Selection By.ID className  then By.cssSelectior and only if all else fails use By.Xpath Selection by CSS  By.CSSSelector  should be preferred over XPath as this is more stable as it is natively supported by browser . XPAth is an abstraction provided by Selenium and not as performant. If XPath is used make sure that you have hand written the XPath and it is performant and not generic in that it has to to brute force search through the entire DOM to find your element. Where ever possible , use By.ID, else By.CSSSelector and in case of no other option use XPath after proper testing. You can use FireFinder plugin for FireFox (first add FireBug) to test your CSS or Xpath (if there is no way you can select by CSS) For example this XPath to finding the drill down element  //*[@id='scTab
Read more

Java Script Development Guidlines

Image
The aim of the page is to give practical and widely adopted industry best practises and guidelines for all phases of JavaScript development lifecycle.   All the necessary tools and frameworks like code analysis and test frameworks are already integrated to our CI system and is ready for use and is already in use by teams Part 1: Sensitizing with JavaScript language     Persons coming from other languages may not appreciate certain coding guidelines that is recommended and set in  SONAR JS Analysis and that is also checked by popular tools like JSHint and JSLint; Example the function below will return 'undefined' and not  'Hello World'.  function main() { return 'Hello, World!'; } main(); ->>return's 'undefined'  This is because in JavaScript semi columns are not mandatory and  JS will add semi colon automatically during code interpretation; So it will add a semicolon after return making the function return nothing; Such and o
Read more