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!