if error encountered in for next loop

[Craig]

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

 

[Mike H]

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