Named Range References

[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.

 

[Bernie Deitrick]

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