View Single Post
  #31   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default trouble returning a workbook level Name object, myWorkbook Names

Hi Jan Karel,

That is right, to exactly reference and use a global name, you MUST
have an activesheet that does NOT contain an identically named sheet
name.


You fool <g, you meant to write:

That is right, to exactly reference and use a global name, you MUST
have an activesheet that does NOT contain an identically named sheet
*level* name.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com