A
AZSteve
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?
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?