Thread: INDIRECT FUNCTION - I want to freeze reference when inserting rows
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dim dim is offline
external usenet poster
  
Posts: 123
Default INDIRECT FUNCTION - I want to freeze reference when inserting
Hi Shane,

Thanks. I'll try that ASAP. I do NOT want any part of it to change. I want
$A$2:$A$101 to stay EXACTLY the same regardless of rows inserted into Row 2.

I dont want particularly to use INDIRECT. I dont care what I use, I just
want the references to STAY THE SAME when rows are inserted!

Thanks, I'll see if that works and get back.
Reply With QuoteReply With Quote