VBA error handling

[nancymc]

Hi! I'm trying to add code to my macro inside a loop, where if an error occurs on a certain line of code it will do a different action and then resume loop. I'm not sure where to place code. For example:

Loop start
code
code
code

Line of code that I want to skip if error occurs

End of loop

What error handling code do you use and where do you place it? And where do you put alternative action?

Thanks!

 

[Marcelo Branco]

Take a look at
http://www.cpearson.com/excel/errorhandling.htm

M.

 

[Norie]

What error are you trying to handle?

 

[nancymc]

The link cleared it up. thanks so much!

 

[Marcelo Branco]

The link cleared it up. thanks so much!

You are welcome. Thanks to the late Chip Pearson who shared his knowledge on his magnificent site. I have no words to acknowledge his exceptional work.
See
https://www.mrexcel.com/forum/loung...-website-ever-helped-you-please-jot-note.html

M.