| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Common range name for 2 sheets
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
| range of data from different sheets | Charts and Charting in Excel | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| How do I multipy a range of cells by a common number? | Excel Worksheet Functions | |||
Threaded Mode
