I have successfully run multiple macros in separate sub routines but I am now trying to run a macro (in the same workbook) at the end of another macro with code.
here is an abridged version of the code
Can someone advise what I am doing wrong with the last command to Call the other macro. I tried AplicationRun but that didn't work.
Please Login or Register to view this content.
Any assistance is greatly appreciated.
Mike
The syntax is correct assuming the other macro takes no parameters and is correctly scoped. What happens when you run this?
Remember what the dormouse said
Feed your head
Where is Other_macro located and how is it declared?
If posting code please use code tags, see here.
Thank you for the quick replies
To answer both questions ...
I receive a compile error
Expected Variable or procedure, not module
But when I check the second Macro it works and appears ok
here is the actual end of the main macro - you will see the actual "call" in the second last line
here is the start of the macro that was being calledPlease Login or Register to view this content.
Not sure if posting this note helpsPlease Login or Register to view this content.
As always, I appreciate any help or advice
Mike
Last edited by MikeMeerkat; 01-14-2015 at 07:19 PM.
Did you give the module and macro the same name? If so, change the module name.
Dear romperstomper
what a champion - I don't know why it works but it worked!
Thanks so much.
As we say in Melbourne - 3 votes (best on ground)
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks