Named Range References

  • Thread starter Thread starter jamescorcoran
  • Start date Start date
J

jamescorcoran

If I have a named range, but want to reference it starting in a row
where it usually doesn't start (i.e. on another sheet, range begins in
row 2, on this sheet want it to start on row 10), how do I do this?
Excel doesn't do it automatically.
 
James,

Select the range - starting with row 10 - that you want to name, then in the name box type

'Sheet Name'!RangeName

and press enter. Of course, replace Sheet Name with the actual sheet name, and RangeName with your
name. Then you will have a name that is local to that sheet.

HTH,
Bernie
MS Excel MVP
 
Back
Top