Autofill VBA without specific cell reference

[jamesfbeard]

Hi all,

I have another VBA question - I have a row of cells that from Column B to I that I need my macro to autofill down to the last cell that appears in column a. The issue is everytime I run the macro the last row will always change where it appears. Sometimes it could be row 10, sometimes it could be row 1000. It changes. Column A's last cell can also change. How am I best doing this?

Thanks!

 

[JLGWhiz]

Use a variable to define your last row with data, no matter which column it is in.

Dim lstRw As Long
lstRw = ActiveSheet.Cells.Find("*", , xlFormulas, xlPart, xlByRows, xlPrevious).Row
ActiveSheet.Range("B1:I" & lstRw).FillDown