HI all, I am still pretty new at this VBA stuff. I have a need to select a
formula in a spreadsheet and fill it down to the last cell possible, then
offset over the the right 9 cell and Autofill again, offsett 9 cells and
repeat until it can't find a activecell with info in it.

The problem is the cells I am Autofilling are all different amounts of fill
some are 600 rows and some are 6000.

Please help if possible.
--
Pete