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
|