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)
"Darin Kramer" wrote in message
...
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!