I find this easier......couple less steps.

Type the formula in A1

Type A1:A29000 in name box and hit ENTER.

CTRL + d to copy down.


Gord Dibben MS Excel MVP


On Mon, 26 Feb 2007 14:38:18 -0800, Gary''s Student
wrote:

say we have a formula in A1 and we want to copy it to A2 thru A29000
1. select A1 and do the copy
2. go to the address bar ( just to the left of the formula bar) and type in
A2:A29000
this will select the big range
3. just paste