Why does the code stop where it stops?

[srosk]

This seems too basic, but I don't understand.

2Import_3Formula r, "H", "=abs(RC6-RC7)"

My sheet has 32 rows, including a header. Rows 33 onward are blank. Except Column H, which has a value of 0 in rows 33-55. How can I stop it at the last row? There could sometimes be 2-300 rows. Thanks!

 

[Joe4]

Pick a column that will always have data in it for any populated row. Then use that to dynamically find where the last row is.
So, let's say that it is column "C". Then we can use this code to dynamically find the last populated row in column C.

Dim lastRow as Long
lastRow = Cells(Rows.Count, "C").End(xlUp).Row

 

[srosk]

Pick a column that will always have data in it for any populated row. Then use that to dynamically find where the last row is.
So, let's say that it is column "C". Then we can use this code to dynamically find the last populated row in column C.

Dim lastRow as Long
lastRow = Cells(Rows.Count, "C").End(xlUp).Row

Thanks! So I am kinda new to all of this. I added the code, but nothing new happened. I am sure I am forgetting to do something obvious...

[CODEDim lastRow As Long
lastRow = Cells(Rows.Count, "A").End(xlUp).Row
VestingReport2Import_3Formula r, "H", "=abs(RC6-RC7)"][/CODE]

 

[Joe4]

What exactly is this?

2Import_3Formula r, "H", "=abs(RC6-RC7)"

That does not look like any sort of valid code I have ever seen.

Your post is missing some important details.
Can you post the WHOLE VBA procedure that you are trying to apply this to?