Thread: Reference a workbook level named variable.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Unger Dave Unger is offline
external usenet poster
  
Posts: 153
Default Reference a workbook level named variable.
Hello,

Just a followup to let you know I did come up with a solution.

I changed w.[Bk] to Evaluate(w.Names("bk").RefersTo). For some reason, the long form works just fine. I'm still hoping someone can enlighten me.

regards,

DaveU
Reply With QuoteReply With Quote