Thread: INDIRECT FUNCTION - I want to freeze reference when inserting rows
View Single Post
  #1   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 rows
Hi folks,

I have a named range from Cell A2 to Cell A101 in a workbook.

This is entered in the Define Name - Refers To box as:

= INDIRECT(Sheet1!$A$2:$A$101)

When I insert rows in row 2, my references steadily change to $A$3:$A$102
then $A$4:$A$103 an so on.

I need my references to stay the same when rows are inserted. IM GOING
INSANE WITH THIS!

Please help!!!!
Reply With QuoteReply With Quote