Click on the cell with the formula (say A1) and COPY
Then, in the name box, put A2:A35000 and press enter.
Then Paste (CTRL/V)

This should fill the selection with your formula.

--

iculookn2 Wrote:
*There has to be an easier way to do this*. I am copying a formula i
make in the first cell down to like cell 35000 in that same column. How
can i do this quickly w/o clicking on the cell after the formula and
dragging down for like 2 minutes to cell 35000?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535523