I have a Macro that I would like to run one macro after another.
I have the macro that I execute which has Application.Run ("Macro10") then Application.Run ("Macro11").
When that finishes, the next sheet is selected and I want the next macro (Macro11) to execute.
I get the error - run time error 1004 cannot run the macro. The macro may not be available in this workbook or all macros may be disabled.
What have I done wrong or is it not possible to do this?
Bookmarks