Remove Error
 

I do not want the #Value error to display in any cell of my worksheet.
How can this be done?

PLease provide complete steps to resolving.

Thx


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=483146

Remove Error
 

In the menu

Edit=goto=special
select
Formulas and Errors
hit the delete key.

in code

On Error Resume Next
cells.specialcells(xlformulas,xlErrors).ClearConte nts
On Error goto 0

--
Regards,
Tom Ogilvy


"oberon.black"
wrote in message
news:oberon.black.1y6poa_1131464116.0813@excelforu m-nospam.com...

I do not want the #Value error to display in any cell of my worksheet.
How can this be done?

PLease provide complete steps to resolving.

Thx


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile:
http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=483146

Remove Error
 

Another approach might be to nest your formulas in an iserror function. Say
your formula is =a1/b1
You could put
=If(ISERROR(a1/b1)=true,"",a1/b1)

This would show the result of a1/b1 only if it was not an error otherwise it
would show a blank cell.


"Tom Ogilvy" wrote in message
...
In the menu

Edit=goto=special
select
Formulas and Errors
hit the delete key.

in code

On Error Resume Next
cells.specialcells(xlformulas,xlErrors).ClearConte nts
On Error goto 0

--
Regards,
Tom Ogilvy


"oberon.black"
wrote in message
news:oberon.black.1y6poa_1131464116.0813@excelforu m-nospam.com...

I do not want the #Value error to display in any cell of my worksheet.
How can this be done?

PLease provide complete steps to resolving.

Thx


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile:
http://www.excelforum.com/member.php...o&userid=26732
View this thread:
http://www.excelforum.com/showthread...hreadid=483146