Visual Basic sub routine command??

[Guest]

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

 

[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)

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 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

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.