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.