Calling a macro from within a macro

[rendezvous]

If I have 2 macros, TEST and TEST2, how can I call TEST2 from within the first macro TEST?

Sub TEST()
ActiveCell.FormulaR1C1 = "SAY HELLO"
Range("A2&quot.Select
End Sub

Sub TEST2()
ActiveCell.FormulaR1C1 = "SAY GOODBYE"
Range("A3&quot.Select
End Sub

thanks

 

[SkipVought]

Hi,

Sub TEST()
    ActiveCell.FormulaR1C1 = "SAY HELLO"
    Range("A2").Select
    Test2
End Sub

That simple Skip,
Skip@theofficeexperts.com

 

[Mightyginger]

If your code is in, say, Module1 then is you type Module1. it'll display all the subs in Module1 then pick it.

so Module1.Test2

 

[RobBroekhuis]

But you don't have to specify the module, unless it resolves an ambiguous macro name.
Rob