| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range name: Change from sheet specific to global
I have a number of range names that are specific to one worksheet within my
workbook. I'd like to change them to apply to the entire workbook. Is there an efficient way to do this? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range name: Change from sheet specific to global
Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager has
this as a feature (localize or globalize the name). You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp CinqueTerra wrote: I have a number of range names that are specific to one worksheet within my workbook. I'd like to change them to apply to the entire workbook. Is there an efficient way to do this? Thanks in advance! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range name: Change from sheet specific to global
ps. And it really makes working with names much easier. Keep it handy.
CinqueTerra wrote: I have a number of range names that are specific to one worksheet within my workbook. I'd like to change them to apply to the entire workbook. Is there an efficient way to do this? Thanks in advance! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete range on another sheet when checkbox is unchecked | Excel Discussion (Misc queries) | |||
| Change scales from reference cells value for a chart in a separate sheet | Charts and Charting in Excel | |||
| How to copy records containing a specific date range to new sheet? | Excel Worksheet Functions | |||
| Sum of 3 nos. into 1 cell in another sheet relevant to specific da | Excel Discussion (Misc queries) | |||
| Copying Specific Values From Sheet | Excel Discussion (Misc queries) | |||
Linear Mode
