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?