Thread: Stopping reference following when rows are inserted.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Stopping reference following when rows are inserted.
Use the INDIRECT function.
--
David Biddulph

"dim" wrote in message
...
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