Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get current value of cell containing formula
Using the Excel object model (in Excel 2003), how can one obtain th current value from a cell containing a formula? Similarly, how can on obtain the current font.Color of a cell whose color is determined by conditional format -- jgreifPosted from http://www.pcreview.co.uk/ newsgroup acces |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
get current value of cell containing formula
msgbox Range("A1").Value
You secod question is much more difficult (assuming the font color is being produced by conditional formatting) and can only be achieved in a round-about way. See Chip Pearson's page on this topic: http://www.cpearson.com/excel/CFColors.htm -- Regards, Tom Ogilvy "jgreif" <jgreif.1pk8yn@ wrote in message ... Using the Excel object model (in Excel 2003), how can one obtain the current value from a cell containing a formula? Similarly, how can one obtain the current font.Color of a cell whose color is determined by a conditional format? -- jgreifPosted from http://www.pcreview.co.uk/ newsgroup access |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
get current value of cell containing formula
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a formula that doesn't change current cell if false? | Excel Worksheet Functions | |||
How to use the rownumber of the current cell in a formula | Excel Worksheet Functions | |||
formula to change current cell value | Excel Worksheet Functions | |||
formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
Can I get current #row or #column in cell formula? | Excel Discussion (Misc queries) |