oh yeah! that was it!!! I can't believe I didn't think of that!
thanks!!

"Dave Peterson" wrote:

You sure?

If I used a formula like:
=sheet2!$a$1

I could copy|paste and the address never changed.

But if my formula didn't have those $'s, then the address changed.


Ninjapowa wrote:

I have a cell with a formula in sheet1 which points to another worksheet cell
(sheet2!$A$1). Now I want to copy this cell to another cell in sheet1, but
Excel keeps shifting the cell value in my formula (sheet2!$A$2)... How can I
tell it to just copy paste normally without excel changing my formula
targets?!

thanks!

--

Dave Peterson