<<<"It is very important that if you create a formula like this one, =a1^2,
you define it when you have b1 selected so that the formula will refer to
the cell to the left of the cell in which you use the formula by name."


Unless, of course, you use an absolute reference:

=Sheet1!$A$1^2

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Tyro" wrote in message
...
If you create a formula such as =a1^2 and call it MySquare, then whenever
you use it in a cell say B3, you put: =MySquare, that will take the value
in A3 and square it. The name of the formula does not change. Perhaps you
could give us an example of what you are trying to do. It is very
important that if you create a formula like this one, =a1^2, you define it
when you have b1 selected so that the formula will refer to the cell to
the left of the cell in which you use the formula by name.

Tyro


"tmkeny" wrote in message
...
I have been trying to do this for years and finally decided I would read
all
the help stuff when I started using excel 2007. But to no avail. Maybe
it
can't be done but I doublt it. It's really simple.
When I name a formula in a cell and subsequently copy that formula to
another cell to calculate a new set of figures I want the name to go with
it.
Instead I have to redefine the name to the new cell each time. The name
is
be used throughout the workbook in stationary cells.
--
tmk