Thread
:
Continuous Macros
View Single Post
#
14
Posted to microsoft.public.excel.programming
Beep Beep
external usenet poster
Posts: 101
Continuous Macros
Thanks Everybody that has responded. I hate to amit it but I was using the
name of the file as opposed to the different names of the worksheets. Also
Don was correct in that I had two macros named the same. This happened
because I had opened another workbook that also had the same macro name and
it was seeing two. O well more to learn.
Thanks again
Frank
"Don Guillett" wrote:
That means that there are TWO of them.
--
Don Guillett
SalesAid Software
"Beep Beep" wrote in message
...
Alan I forgot to add the message I got:
"Ambiguous Name Detected: AptOneInvoice
"Alan" wrote:
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
Reply With Quote
Beep Beep
View Public Profile
Find all posts by Beep Beep