Assume the range to which the formula is being applied is A1:A9000, and the
formula is being applied to cells B1:B9000.

Go the bottom of the range by selecting cell A1 and hitting CTRL + down
arrow. Go to B9001 and enter a period, or some other holding character. Hit
CTRL + Up arrow to go to B1. Enter your formula. SHIFT + CTRL + DOWN arrow.
CTRL + D.

Dave
--
Brevity is the soul of wit.


"chiechka" wrote:

Any suggestions on how to copy a formula to 9000 rows?