Hi Asser
Evaluate("Xmax")

HTH
Cordially
Pascal

"Jazzer " a écrit dans le message de
...
Hi,

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

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

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

- Asser


---
Message posted from http://www.ExcelForum.com/