Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning the value of a named formula
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning the value of a named formula
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning the value of a named formula
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 -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula returning "A value used in the formula is of the wrong dat | Excel Worksheet Functions | |||
Looking up a named range and returning value into a cell | Excel Discussion (Misc queries) | |||
Formula not returning value | Excel Worksheet Functions | |||
OFFSET function in named range returning wrong # of rows | Excel Worksheet Functions | |||
Returning the x value of a formula | Excel Discussion (Misc queries) |