How to create an array reference that won't move

J

John

How can I create a named range for A1:A500 that never grows/shrinks
after cutting and pasting, etc.? I.e, I want the named range to always
refer to A1:A500.
 
P

Peo Sjoblom

Use indirect

define>name and use

=INDIRECT("Sheet1!A1:A500")

replace Sheet1 with the name of the sheet
 
D

Don Guillett

insert>name>nameit "dontmove"
in the refers to box
=indirect("Sheet1!$a$1:$a$500")
 
Top