Returning the value of a named formula

  • Thread starter Thread starter Jazzer
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine if a chart is embedded or not 7
Modifying a Defined Name's Contents 10
Save As and new workbook new name used in existing code 8
Indirect formula errors if file is closed 1
Weighted randbetween text list 3
Copy value from changing cells without VBA 1
Supressing a #VALUE! error returned? 3
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0

Back
Top