Returning the value of a named formula

J

Jazzer

Hi,

I've defined some names in my workbook and I try to read the value o
those in my VB application.

The simple ones, which are like "=data!$A$2" (named as Xmin) are eas
to read with Range(ActiveWorkbook.Names("Xmin").Value).

How do I get the value of a named formula? (for exampl
=MAX(INDIRECT("data!A:A")) that is named as Xmax)

- Asse
 
J

Jazzer

Hi & thanks for a quick reply

In case of a simple named range, evaluate works, but if I use it i
this "Xmax" situtation, I get an "Error 2023".

Should it be possible to use evaluate, when the name is actually
formula?

- Asse
 
Top