Visual Basic sub routine command??

M

minsteness

Can anyone tell me what the command is to call another macro from within an existing macro? I am using Excel 98 for Macintosh

For example, I am running Sub Macro (9) and I want to run Sub Macro (10). I have tried recording a macro and selecting Tool
Macro
Macros..
Ru
Macro 1

It gives me the command: Application.Run Range()

when I run the new macro I then get this message: Compile Error, Argument not optional

My main problem is that I have created a macro which too large and when I run the original Macro, I get this message: Compile Error, Procedure too large. So, I need to cut up the program into sub routines

Thanks for your assistance! =

Mark Insteness
 
B

Bob Phillips

Sub Macro1()

Macro2

End Sub

or with parameters

Macro2 Param1, Param2

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

minsteness said:
Can anyone tell me what the command is to call another macro from
Click to expand...
within an existing macro? I am using Excel 98 for Macintosh.
For example, I am running Sub Macro (9) and I want to run Sub Macro
Click to expand...
(10). I have tried recording a macro and selecting Tools
Macros
Run
Macro 10

It gives me the command: Application.Run Range()

when I run the new macro I then get this message: Compile Error, Argument not optional.

My main problem is that I have created a macro which too large and when
Click to expand...
I run the original Macro, I get this message: Compile Error, Procedure
too large. So, I need to cut up the program into sub routines.
 
Top