How to define a fixed/unlinked named range?

  • Thread starter Thread starter Perspek
  • Start date Start date
P

Perspek

I've seen the answer for this somewhere, but it is eluding me now.

How do I create a named range that will never change regardless of wha
I do to the spreadsheet?

i.e.
I want to create a named range $A$1:$B$5 and I never want it to change
I highlight the cells, insert --> names --> define and call it Bob.
Now, if I select column A and Insert Column, when I go look at Bob, i
is now $B$1:$C$5. Unfortunately, that is not what I want. Excel i
being smarter than I want it to be.

Any suggestions
 
Try this:

Insert>Names>Define
Name: rngMyFixedRange
Refers To: =INDIRECT("$A$1:$B$5")

Note: being what Excel will consider a "dynamic range", it won't lis
in the Names dropdown or in the GoTo dialog.

Does that help?

Ro
 
Back
Top