Hi Frank,

I would suggest creating a new macro to call your macros vs. calling one
from another. None of the macros would work stand alone without error except
Macro7 which doesn't call another macro. I would call them using something
like this:

Sub RunMacros()
Call Macro1
Call Macro2
Call Macro3
Call Macro4
Call Macro5
Call Macro6
Call Macro7
End Sub


Alan


"The only dumb question is a question left unasked."


"Beep Beep" wrote in message
...
I have a number (7) of macros and would like to go to each one when the
previous one is finished running. I forgot the vba command to put at the
end
of the macro to direct it to the next macro.

Thanks
Frank