ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   On Error Resume Next (when next statement is Do Loop ...) (https://www.excelbanter.com/excel-discussion-misc-queries/111607-error-resume-next-when-next-statement-do-loop.html)

EagleOne

On Error Resume Next (when next statement is Do Loop ...)
 
2003

If the next code-line after On Error Resume Next is a Do .... Loop,
is the next "statement" the entire Loop or the first code-line
in the Do .... Loop?


Bob Phillips

On Error Resume Next (when next statement is Do Loop ...)
 
It applies until the error handling is reset with an On Error Goto 0, but
each line will be executed even if the previous on errors.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"EagleOne" wrote in message
ups.com...
2003

If the next code-line after On Error Resume Next is a Do .... Loop,
is the next "statement" the entire Loop or the first code-line
in the Do .... Loop?




EagleOne

On Error Resume Next (when next statement is Do Loop ...)
 
Thanks Bob


Bob Phillips wrote:
It applies until the error handling is reset with an On Error Goto 0, but
each line will be executed even if the previous on errors.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"EagleOne" wrote in message
ups.com...
2003

If the next code-line after On Error Resume Next is a Do .... Loop,
is the next "statement" the entire Loop or the first code-line
in the Do .... Loop?




All times are GMT +1. The time now is 04:21 AM.

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