on error

D

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
 
C

Corey ....

for example

:ThisPlace

code
code
code
on error goto ThisPlace
code
code
code



Corey....
 
J

JLGWhiz

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

ThisPlace:
 
N

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.
 
Top