Gord,

Thank you, this helps!
-Me


"Gord Dibben" wrote:

Me

Select A1 then in Name Box to the left of the Formula Bar type in A1:A900 and
hit ENTER key.

Type your formula in A1 and hit CTRL + ENTER.

If formula is already entered in A1, hit F2 then CTRL + ENTER after selecting
the range.


Gord Dibben Excel MVP

On Fri, 4 Mar 2005 14:25:01 -0800, "Me" wrote:

I have a worksheet function for a cell.
Now I would like to copy this function for all the rows
in this column. How can it be done?

Like copy A1 to A2 thru' A900

Thank you,
-Me