View Single Post
  #32   Report Post  
Posted to microsoft.public.excel.programming
Brian Murphy Brian Murphy is offline
external usenet poster
 
Posts: 126
Default trouble returning a workbook level Name object, myWorkbook Names

Thank you for your help, Jan Karel.

My code is now working the way I need it to.

Hurray,

Brian Murphy
Austin, Texas


"Jan Karel Pieterse" wrote in message ...
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