Run Module1 first then automatically run Module2

This is probably simple but I have two modules that I had to break up
because it was too large. Anyway, I cannot figure out what object or
syntax or whatever to use to go to Module2 when it is done with Module
one. Could someone point me in the right direction.

Thanks in advance,

Bowbender

Not modules but macros.

Call the macros in Module 2 from the last macro in module 1.

--
HTH

Bob Phillips

<Bowbender@gmail.com> wrote in message
news:1127230069.742606.97300@g43g2000cwa.googlegroups.com...
> This is probably simple but I have two modules that I had to break up
> because it was too large. Anyway, I cannot figure out what object or
> syntax or whatever to use to go to Module2 when it is done with Module
> one. Could someone point me in the right direction.
>
> Thanks in advance,
>
> Bowbender
>

Sorry bout that, I am in no way any sort of expert. How would you call
it exactly, I am really lost here.

Thanks

Sub RunAllMacros()
Call Macro1 '(or whatever the first macro name is)
Call Macro2 '(or whatever the second macro is)
end sub

ps - Macros are stored in modules, you cannot call a module... only a macro

hope this helps


"Bowbender@gmail.com" wrote:

> Sorry bout that, I am in no way any sort of expert. How would you call
> it exactly, I am really lost here.
>
> Thanks
>
>

Sorry, found it. It seems if you place the name of the macro inside
the other, it will run it. Man do I feel dumb.

Thanks again.