How can I insert a run macro command in the IF function?
 

How can I insert a run macro command in the IF function?
Thank of support.
Emil.

How can I insert a run macro command in the IF function?
 

Use the call command to run a macro from anywhere in a macro.

i.e. Assume you have a macro called "OtherMacro", that you require
running if the contents of a range, called "Answer" is equal to 5:-

Sub Example()

If Range("Answer").value = 5 then
Call OtherMacro
End If

End Sub

How can I insert a run macro command in the IF function?
 

Thanks millions,
It was very useful for me
Emil

"Stewart" a scris:

Use the call command to run a macro from anywhere in a macro.

i.e. Assume you have a macro called "OtherMacro", that you require
running if the contents of a range, called "Answer" is equal to 5:-

Sub Example()

If Range("Answer").value = 5 then
Call OtherMacro
End If

End Sub

How can I insert a run macro command in the IF function?
 

Use the call command to run a macro from anywhere in a macro.

i.e. Assume you have a macro called "OtherMacro", that you require
running if the contents of a range, called "Answer" is equal to 5:-

Sub Example()

If Range("Answer").value = 5 then
Call OtherMacro
End If

End Sub

How can I insert a run macro command in the IF function?
 

Use the call command to run a macro from anywhere in a macro.

i.e. Assume you have a macro called "OtherMacro", that you require
running if the contents of a range, called "Answer" is equal to 5:-

Sub Example()

If Range("Answer").value = 5 then
Call OtherMacro
End If

End Sub