View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
 
Posts: 587
Default Reference a workbook level named variable.

what is important is Names

Worksheet.Names, property
This property returns a Names collection that represents all the
specific names for spreadsheets

isabelle


Le 2013-09-06 23:58, Dave Unger a écrit :
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