A
Andre Achtermeier
hi,
i defined a Name "MyName" like
=locACTIVE_Template!$P$49;locACTIVE_Template!$P$86
in VBA i wrote
Dim rng As Range
Set rng = ActiveWorkbook.Names("MyName").RefersToRange
but the code fails and the RefersToRange is nothing.
any idea?
i defined a Name "MyName" like
=locACTIVE_Template!$P$49;locACTIVE_Template!$P$86
in VBA i wrote
Dim rng As Range
Set rng = ActiveWorkbook.Names("MyName").RefersToRange
but the code fails and the RefersToRange is nothing.
any idea?