View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steven Revell Steven Revell is offline
external usenet poster
 
Posts: 35
Default 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!