Call Macro
Hi,
You don't need to use Call but using it won't give the problem you describe
and there is nothing wrong with the 2 code snippets you have provided. Just
one other possibility, are you sure it's failing to call the second sub? It
could just be that the second sub is doing nothing i.e. not doing what you
expect.
Put a line in the second sub you are 100% sure will work
msgbox("In sub 2")
and see if the message box comes up.
Mike
"Beep Beep" wrote:
I have a number of macros in one macro on in Personal.xls
The first one works and then stops. I didn't put all the code here just the
last two lines of the first macro and the first line of the second one. Any
reason it stops after the first macro???
Call Print68005xChart
End Sub
_______________________
Sub Print68005xChart()
Thanks
Frank
|