View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default if error encountered in for next loop

Craig,

Error handling in VB isn't a one-line answer, there are many options. Have a
look at Chip pearson'e site.

http://www.cpearson.com/excel/ErrorHandling.htm

Mike

"Craig" wrote:

How do I program if an error gets encountered during running commands within
a for next loop, to not stop the macro but continue processing the commands
until the loop ends?

how do I program to tell me what the error exactly was while the loop was
processing so I know what it was to fix it?

thank very much for any assistance