![]() |
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