Heya again,
Yeah i know the difference between absolute and relative. What is confusing
me is that the cell that isnt absolute ie: =Sheet1!B1 seems to behave as an
absolute reference. I have moved B1 to several other locations and checked
the result on the the link in cell A1 and it always refers to B1 in both
cases ie: paste special and =. I would have assumed that it wouldn't but it
does. That's either very strange or christmas is catching up on me!!

"JE McGimpsey" wrote:

See the "The difference between relative and absolute references" topic
in XL Help.


In article ,
"emerb" wrote:

What is confusing me is why with paste special you get the =Sheet1!$B$1 but
by using the equal sign you get =Sheet1!B1. How do you know which method is
the most appropriate?