Try this:

With your formula in A2, select A2, press and hold the SHIFT key, then
press PAGE DOWN until you get to (or near) A1000 (with shift depressed,
use the arrow keys up/down to fine tune the last few cells) so that all
the desired cells are highlighted. Release the SHIFT key and press
CTRL+D. This will fill your formula down the selected range.

Does this work for you?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=382920