Type the cell references in the name box and press enter
(to the left of the column header A and above row header 1)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Brian" wrote in message
...
I have a worksheet with approx. 37000 account numbers.

I need to format another sheet to pull these numbers into a text format,
no problem.

My question: When I want to copy a formula into all 37000 rows, what is a
quick way to select row 1 thru 37000 and paste the formula without
scrolling for 10 minutes?

P.S. I don't want to select the entire column.