You can do it with a macro.

Sub DoFillDown
Range("A1:A29222").FillDown 'Fill Down from A1 to A29222
End Sub


"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!