Autofill a Column

[ryannjohnsonn]

I am building a macro to minipulate a huge spreadsheet to purge out un needed information and insert a few formulas at the end. The file has between 30,000-80,000 rows usually. I'm trying to make it autofill down to the last row (where there's data in the other columns), but I can't seem to get it to stop at that point, it continues going until around 150,000 rows.


This is the code I am currently working with. I want this to fill down from AJ2 until the last row. This is built into a larger macro that does a few other things as well.

Please Login or Register  to view this content.

[mike7952]

Maybe this

Please Login or Register  to view this content.

[ryannjohnsonn]

That for the most part works, but it's filling in one extra row below the rest of my data. What's the easiest way to make it stop a row sooner?

[mike7952]

My bad just add -1

Please Login or Register  to view this content.

[ryannjohnsonn]

Worked great, thanks!