One way, with the formula pasted in C1

Click inside the namebox*, enter the range: C1:C720
Press Enter, this selects the range with C1 active
*the box with the dropdown just to the left of the formula bar

Click inside the formula bar, press CTRL+ENTER
This will fill the entire range (same as dragging down from C1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Wowbagger" <Wowbagger~~ wrote in message
...
Thank you.

Now, is there a quick and easy way to paste copies in a cell down to the
last used row?

For example: if I have data in A1 : A720, what is the quickest way to
paste the formula into cells C1 : C720 without having to scroll and scroll
and scroll and .... ?