Thread: links problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
driller driller is offline
external usenet poster
 
Posts: 740
Default links problem

if you have link source not-so-many-cells, i prefer to "name" the source cell.
and the link formula on another sht. shall contain such name.
--
regards,



"PBcorn" wrote:

how can i make a link to cells in another workbook so that if the source
cells are cut and pasted, the link will still refer to the same cells, eg if
cut and paste down one, a1 does not become a2.