vba code explanation

[jtsains]

Does anyone know the difference between these two codes?

For i = 2 To Range("D" & Rows.Count).End(xlUp).Row

and

For i = 2 To Range("A2").End(xlDown).Row

can you please help me understand what is happening with each?Thank you,Jeff

 

[wigi]

Code 2 has a cell in column A as the reference cell instead of D...

But on a more interesting note, code 1 will go to the last row, which is based on contents in column D. You determine the last row by going bottom up from the very last row of the sheet until you find a non-empty cell.

Code 2 is similar but you start in cell A2. You go downwards until to encounter an empty cell in column A. Which is not necessarily the same as in code 1 (even if you used the same column A or D).

 

[jtsains]

Thank you Wigi,I understand the A vs D column. Does the ".Count" indicate that it starts at the bottom and goes up?I have a string of data in one column and a header. I want to run the code with the For/Next statement until the end of the data in that column but it must start with Row 2, and not include A1 or D1 due to the headers. Will either code create problems with what I am trying to do?Thank you again for your help.JEff

 

[wigi]

Hi Jeff

If you have no empty cells in the column, between row 2 and the last row of data, both methods will be similar. You can choose either method.