After copying your formula, select the first cell to copy to in the column,
scroll down 29,222 rows, hold down the shift key and select the last cell.
All cells in between will be selected. Click paste. HTH
--
Sincerely, Michael Colvin


"newyorkjoy" wrote:

thanks for all your previous help. Now, here is the question.

I need to copy a formula down about 29,222 rows. How do I do that without
having to drag the fill handle from row 1 through row 29,222?
--
newyorkjoy
thanks for the help!