Execute a macro at the completion of another

[tushargarg729]

Hello,

is it possible to run another macro when one completes.

Sub Test()
....

Run macro()
End Sub

something to the above effect. My code is apparently too long and i
get the procedure too long error. I have tried to cut the code down
but to no avail. the only option i see is to execute it in parts but
all in one process. kind of like a A then B then C... stream. So my
two questions are:

1) can you execute/run a macro from a macro
2) can you take one macro and break it up into parts so it executes
piece by piece solving the procedure too long error.

Thanks

Tushar

 

[Jef Gorbach]

Call modulename.macroname
(can omit module name if in default Module1)

 

[tushargarg729]

so the code looks like

sub test()
....
Call test2()
end sub()