View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teacher Help Teacher Help is offline
external usenet poster
 
Posts: 1
Default Lock reference cells for links within workbooks

How do I lock the source cell when creating a link within worksheets? Right
now the cell changes if I insert cells, and i want the cell reference number
to always remain the same, so the cell linked to it changes as I change the
linked cell.