How to create an array reference that won't move

  • Thread starter Thread starter John
  • Start date Start date
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.
 
Use indirect

define>name and use

=INDIRECT("Sheet1!A1:A500")

replace Sheet1 with the name of the sheet
 
Back
Top