Reference a workbook level named variable.
hi Dave,
Name is a member of the application "workbooks" not of sheets
so you have to define sheet in description
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
|