View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mika Mika is offline
external usenet poster
 
Posts: 48
Default annoying bell when trapping errors

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