annoying bell when trapping errors

M

Mika

Hi,

In a routine that operates with precedents I have :

On error resume next
Arrows = MyCell.Precedents.count
MyCell.ShowPrecedents

If Mycell doesn't have precedents the On error statement allows to
continue as you know, however the bell of error messages still
sounds....How can I suppress that ??

Rgds
Mika
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Trapping Problem 8
Set Error handling INSIDE error-trap 6
Is my Error trap working??? 10
Filter, Delete and Error handling - need help 4
Hierarchy of Codename and error catching if no worksheet. 1
Error trap only works once 2
On error resume next 0
Annoying errer message 1

Top