ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Run time errors (https://www.excelbanter.com/excel-discussion-misc-queries/73166-run-time-errors.html)

famdamly

Run time errors
 

I'm looking for a way to ignore them if you know what I mean.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=515216


Ken Johnson

Run time errors
 
Hi famdamly,
On Error Resume Next
placed before the line likely to produce the error

On Error GoTo 0
to reactivate normal error reporting

Ken Johnson


famdamly

Run time errors
 

That seems simple enough, much appreciated.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=515216


Ken Johnson

Run time errors
 
You're welcome famdamly. Thanks for the feedback.
Ken Johnson



All times are GMT +1. The time now is 07:13 PM.

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