| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop time seems dependent on unrelated workbook - Why? | Excel Worksheet Functions | |||
| If statement - Loop? | Excel Discussion (Misc queries) | |||
| Loop gone crazy | Excel Discussion (Misc queries) | |||
| Do Loop | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Hybrid Mode
