I currently have a named range on one worksheet that i can access via just the named range (i.e. range("namedrange")) through one userform but not through another. The second userform required a sheet name before every namedrange reference in my code.

Any thoughts on why one form is behaving differently than the other? Both forms are accessed from the same sheet (albeit different than the location of the namedrange).

thanks,
Jon



Dave Peterson wrote:

Since you can only have one global name with a particular name, you'll have
23-Sep-08

Since you can only have one global name with a particular name, you will have to
create a new name, then delete the old local name.

Henry wrote:

--

Dave Peterson

Previous Posts In This Thread:

On Tuesday, September 23, 2008 2:24 PM
Henr wrote:

How can I change a Name scope from local to Global?
How can I change a Name scope from local to Global?
I designed a worksheet and duplicated it, along with the Names. I have
edited the names but now those are scoped for that worksheet only. Name
Manager does not allow me to change the scope.

On Tuesday, September 23, 2008 2:39 PM
Dave Peterson wrote:

Since you can only have one global name with a particular name, you'll have
Since you can only have one global name with a particular name, you will have to
create a new name, then delete the old local name.

Henry wrote:

--

Dave Peterson


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Report Engine, Part 2
http://www.eggheadcafe.com/tutorials...ne-part-2.aspx