Excel2000

I've been scouring the archives for what I want and all posts seem to
advise against it, but I want it!!!

I have a workbook where each sheet has a named range 'Attendance' that is
unique to that sheet and depending on which sheet is selected, clicking
Attendance from the NameBox dropdown will highlight that sheets Attendance
range. I don't know how I accomplished that, since it's been years, but now
I want a similar common name for 2 of the sheets in that workbook. I want
SortRange for those 2 sheets, so when I select either sheet and click
SortRange from the NameBox dropdown, it will highlight SortRange on the
selected sheet.

How can I do this?

--
David