Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |