the only other (error prone) alternative
to adding a blank sheet is:

create a copy of the "blocking" name
delete the blocking name
delete the global name
recreate the blocking name
delete the copy..


it's error prone as the refersto may be too long
for the names.add method (complex formulas or multiarea's.)


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Peter T wrote :

Hi Bob,

B. you cannot access (thru VBA or functions)
a global name IF the same (local) name exists
on the activesheet.

You can, it is more work but it can be done.

AFAIK the only way would be first to activate another sheet. But I
would be interested if you know of way without doing that.

Regards,
Peter T