Auto fill a range based on another cell

Hello all,
I am having a problem and need some assistance. I am auto filling a range of cells on O2 down with a formula and have it stoping all the way down at O12982, the problem i have is that my data can stop before or after that point depending on the report. so how can i say that it should auto fill as long as there is data in A column

Please Login or Register  to view this content.

Thanks

Hi Ricardo, you'll need to EDIT that first post and GO ADVANCED, then highlight the code and click on the # icon to wrap it in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags. It's a firmly enforced rule. will look like this:

Please Login or Register  to view this content.

Then I can give you the code you need, pretty straightforward stuff.

One approach is to declare and solve the "last row" variable and skip the autofill, just enter the formula directly into the entire range:

Please Login or Register  to view this content.

All variables should be declared, so yes, you can have as many declarations as you need. Some people list all declarations separately, others (like me) group them:

Please Login or Register  to view this content.