Prev: copy offset rows
Next: How do I make sorts default to using the header row?
From: AZSteve on 30 Apr 2010 22:35
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?
From: ozgrid.com on 30 Apr 2010 23:11
See http://www.ozgrid.com/Excel/named-ranges-sheet.htm


--
Regards
Dave Hawley
www.ozgrid.com

"AZSteve" <AZSteve(a)discussions.microsoft.com> wrote in message
news:1445CCBB-8624-452B-AEA8-5B9028A43F9B(a)microsoft.com...
> 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?

From: Dave Peterson on 1 May 2010 08:13
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
 | 
Pages: 1
Prev: copy offset rows
Next: How do I make sorts default to using the header row?