Using Autofill in a macro with variable rows

[svconway]

Hi all,

I've searched extensively and have been unable to find the answer I need.

My issue is fairly simple, I'm trying to create a macro that will autofill into column B based on data in column A. Insofar as I can record the macro with a stated range, the range of values changes.

I'm hoping someone can show me how to code my macro so that the autofill function will only populate column B to the end row of column A.

Thanks!

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[mrice]

Once you have recorded your macro for the exact range, edit it so that the row number of the column B range is determined by the last row in A

for instance...

Range("B1:B100")

would become...

Range("B1:B" & Range("A65536").end(xlup).row)


An alternative is

Range("B1:B" & Range("A1").end(xldown).row)

but this one will fail if there are blank cells in A or if there is only one cell in A.