View Single Post
  #2  
Old 06-11-2007, 01:37 AM
ICMoney ICMoney is offline
Senior Member
 
Join Date: Sep 2005
Location: Watching Vids > Playing
Posts: 1,720
Default Re: Excel Help Needed

If you are in c5 and type =a1 that is a relative link. If a1 moves to a2 c5 will now be updated to =a2.

The only way this would not be true is if you use an absolute reference. For example, in c5 you type =$a$1.

If a1 moves c5 will still point to a1.
Reply With Quote