View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default using 'paste link' into seperate tab

.. whats the difference between using the $ and not?
$ signs makes the cell ref absolute, ie fixed
Eg In B1: =$A$1 will fix it to A1,
ie the ref won't change when you copy B1 across or down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---