Reference A Named Formula in VB

[Paul Corrado]

Trying to include a reference the a Named Formula in my program.

The Named Formula is constant integer that changes over time so I do not
wish to hard code that value.

I tried

xyzvalue = Range("namedformula")

and that doesn't work. (Probably because the named formula isn't a range.)

Any help would be appreciated.

TIA

PC

 

[Tom Ogilvy]

xyzValue = Evaluate(thisworkbook.Names("NameFormla").RefersTo)

using evaluate gets rid of the equal sign.

 

[Paul Corrado]

Fantastic!

Thank you very much Tom.

PC

xyzValue = Evaluate(thisworkbook.Names("NameFormla").RefersTo)

using evaluate gets rid of the equal sign.