What is the formula you're using?

Why can't you copy the formula to your various cells and then delete it when
you're done with it?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"garbon2535" wrote in message
...
I have a worksheet with a simple function. I want to be able to move the
function from one cell to another cell and maintain a reference to a cell
in
a certain location relative to the new cell.

Example:

My function is in Cell A3. The Function has a reference in cell A1 which
is
two rows above Cell A3. When I move the function in cell A3 to cell A10
it
still references cell A1. I want it to maintain the relationship it had
and
reference the cell two rows above the new cell which would be cell A8.

When I copy the cell from once place to another I do not have this
problem.
I only experiance this problem with I move a cell. How can I make a
formula
that I can move all around and it will maintain a reference with a cell
two
cells above the formula's cell?