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

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