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

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

--
Regards,
Tom Ogilvy

"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!