Conditional Macro calling within Macro

[Grange2]

Hello,

i have set up a macro that will call on other macros however would like to set up an if condition if one of the first macros runs into an error.

Say Macro 1 is the Initial Macro that is run that calls on Macro 2.
If during Macro 1 it calls on Macro 2 and it runs into an error how do you code for it to call on Macro 3 in this instance?

Any help would be appreciated!

Thank you,

 

[footoo]

Maybe this :

Sub One()
Call Two
End Sub

Sub Two()
On Error GoTo e
'Your code
e: Call Three
End Sub

Sub Three()
'Your code
End Sub

But of course, the result of any actions carried by macro Three before an error will remain.

 

[footoo]

Correction :
"But of course, the result of any actions carried by macro Two before an error will remain."

 

[Grange2]

Awesome Thanks for clearing that up!