How do you reference the cell? I have tried numerous times and cannot get it
right.

Thanks

"Gail Richner" wrote:

Would it not be better to reference the cell where the formula is in case
the results change?


"cahduq" wrote in message
...
I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the
destination
cell. How can I make this work?