Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting Scope of name ranges to particular worksheet
Excel 2003 - I set up one worksheet, assigned ranges and use macros to
process data based on those ranges. Then I made copies within workbook with some changes not involving macros. Surprisingly I saw ranges with same name but "scope" only each particular worksheet. Great because same macros common to these worksheets process only ranges within particular worksheet they are called from. Now with some workbook improvements, ranges are becoming "workbook scope" instead of "worksheet scope". How can I restore "worksheet scopes" without making copies again, since many cells within each worksheet are particular to that worksheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting Scope of name ranges to particular worksheet
See http://www.ozgrid.com/Excel/named-ranges-sheet.htm
-- Regards Dave Hawley www.ozgrid.com "AZSteve" wrote in message ... Excel 2003 - I set up one worksheet, assigned ranges and use macros to process data based on those ranges. Then I made copies within workbook with some changes not involving macros. Surprisingly I saw ranges with same name but "scope" only each particular worksheet. Great because same macros common to these worksheets process only ranges within particular worksheet they are called from. Now with some workbook improvements, ranges are becoming "workbook scope" instead of "worksheet scope". How can I restore "worksheet scopes" without making copies again, since many cells within each worksheet are particular to that worksheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting Scope of name ranges to particular worksheet
I've never seen excel change the scope of names from global to local (or vice
versa). But I have created names and forgotten to make them local. In any case... Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager NameManager.Zip from http://www.oaltd.co.uk/mvp Allows you to convert from local to global and global to local very easily. AZSteve wrote: Excel 2003 - I set up one worksheet, assigned ranges and use macros to process data based on those ranges. Then I made copies within workbook with some changes not involving macros. Surprisingly I saw ranges with same name but "scope" only each particular worksheet. Great because same macros common to these worksheets process only ranges within particular worksheet they are called from. Now with some workbook improvements, ranges are becoming "workbook scope" instead of "worksheet scope". How can I restore "worksheet scopes" without making copies again, since many cells within each worksheet are particular to that worksheet? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting more than one condition and multiple ranges | Excel Discussion (Misc queries) | |||
Deleting all named ranges that have a workbook scope | Excel Discussion (Misc queries) | |||
dynamic setting of data ranges | Charts and Charting in Excel | |||
Setting multiple ranges to print | Excel Discussion (Misc queries) | |||
help with setting up dynamic name ranges | Excel Worksheet Functions |