Thread: on error
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych Tim Zych is offline
external usenet poster
 
Posts: 389
Default 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