Thread: Stopping reference following when rows are inserted.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dim dim is offline
external usenet poster
  
Posts: 123
Default Stopping reference following when rows are inserted.
Hi folks,

I have the following cell reference in Book 2:

='C:\Program Files\systems\My Program\Data1\[Book1.xls]Sheet1'!$A$2

I have a macro that automatically enters data in Book1 by inserting rows. I
need the above reference to NOT change to $A$3, $A$4, $A$5 etc as rows are
inserted.

Reply With QuoteReply With Quote