Checking the result of a formula
 

Hi Steven,

are you looking for the Evaluate method, which evaluates a string as though
it was a formula?

If so take a look at
http://www.decisionModels.com/calcsecretsh.htm
which discusses how to use evaluate

hth
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com

"Steven Revell" wrote in message
...
Hi All,

Is it possible to check what the result of a formula is
within a cell?

Cheers,

Steven

Checking the result of a formula
 

I'm looking for something along the lines of being able to determine,
using code, whether a formula result is of a certain value.

e.g.

=A1/B1

I would want to know whether it is less than 1 and if so then i'd delete
the row.

Thanks,

Steven Revell
Applications Development & Support
Covance Laboratories Europe, UK

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!