ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   annoying bell when trapping errors (https://www.excelbanter.com/excel-programming/281792-annoying-bell-when-trapping-errors.html)

Mika

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


All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com