Help with Recursive VBA

[tddavid89]

I have included below a macro that I am running and want to continue to run, but figure there is a better way to do it. As you can see, all I am doing is copying the cell A1 and pasting its value in column AO starting at row 2 and working my way down, pasting the value in each row. I want to print this about 100 times. Is there a way to do this without typing in every row? (Note: The value of A1 keeps changing due to random numbers, otherwise I would just print Range("AO2:AO102"). Thanks!

Please Login or Register  to view this content.

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

[tddavid89]

This is perfect. Exactly what I was looking for. Thanks!