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