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

In the menu

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

in code

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

--
Regards,
Tom Ogilvy


"oberon.black" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

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" <[email protected]> wrote in message
news:[email protected]...
> In the menu
>
> Edit=>goto=>special
> select
> Formulas and Errors
> hit the delete key.
>
> in code
>
> On Error Resume Next
> cells.specialcells(xlformulas,xlErrors).ClearContents
> On Error goto 0
>
> --
> Regards,
> Tom Ogilvy
>
>
> "oberon.black" <[email protected]>
> wrote in message
> news:[email protected]...
>>
>> 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
>>
>
>