on 9/22/2011, kittronald supposed :
Garry,

When I enter the following, Error 2029 occurs in the Immediate Window ...
why ?

Dim a As Variant

a =
Application.Evaluate(ActiveWorkbook.Names("Fill_Fo rmula").RefersTo)
Debug.Print a



- Ronald K.

What is error 2029?

Why not just enter...

?Application.Evaluate(ActiveWorkbook.Names("Fill_F ormula"))

...without .RefersTo. What made you think you needed to include
..RefersTo to read the valu? My code sample doesn't show that! You only
need to use .RefersTo to write the value...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc