Error types

D

Darin Kramer

last one....

How do you say if cell a1 is error type #value, then put "x"?

Also how do you say if cell a1 is an error, put y?

Thanks

D

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

Tom Ogilvy

if Range("A1").Text = "#VALUE!" then
' put x where?

if iserror(Range("A1").Value) then
' put y where?
 
B

Bob Phillips

If Range("A1").Value = CVErr(xlErrValue) Then
Range("A1").Value = "x"
ElseIf Iserror(Range("A1").Value) Then
Range("A1").Value = "y"
End If


--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top