Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
on error
when looping through my code...if i receive an error...when the error occurs
how can i have it go back to the top of the block of code...so in other words for example Start back here code code code on error go back to "Start back here" code code code |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
on error
for example
:ThisPlace code code code on error goto ThisPlace code code code Corey.... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
on error
Hi Corey, I believe the Label should have the colon after instead of before
ThisPlace: "Corey ...." wrote: for example :ThisPlace code code code on error goto ThisPlace code code code Corey.... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
on error
Avoid using GoTo whenever possible.
Rick Rothstein sums up very nicely the reasons not to use Goto and offers alternatives: http://groups.google.com/group/micro...21f2381df1a2dd Just to add, the opposite of GoTo is the COMEFROM statement (this is funny). http://en.wikipedia.org/wiki/Comefrom -- Tim Zych http://www.higherdata.com Compare data in Excel and find differences with Workbook Compare Free and Pro versions available "dstiefe" wrote in message ... when looping through my code...if i receive an error...when the error occurs how can i have it go back to the top of the block of code...so in other words for example Start back here code code code on error go back to "Start back here" code code code |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error when cell A1 is not active and xlInsideVertical border formatthrowing error 1004 | Excel Programming | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Form Err.Raise error not trapped by entry procedure error handler | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming |