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

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

get current value of cell containing formula
 

Thanks much

--
jgreifPosted from http://www.pcreview.co.uk/ newsgroup acces