on error

[dstiefe]

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

 

[Corey ....]

for example

:ThisPlace

code
code
code
on error goto ThisPlace
code
code
code



Corey....

 

[JLGWhiz]

Hi Corey, I believe the Label should have the colon after instead of before

ThisPlace:

 

[Tim Zych]

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/micr...ramming/browse_thread/thread/a621f2381df1a2dd

Just to add, the opposite of GoTo is the COMEFROM statement (this is funny).
http://en.wikipedia.org/wiki/Comefrom

 

[Noob McKnownowt]

Or you could use:

on error resume next

this will skip the cell that is causing the problems and execute the rest of
the code.