if error encountered in for next loop
 

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

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