ruuning part of a macro from another macro

[pauluk]

Hi All,

Just a little help please,

I know how to run another macro from the current macro application.ru
but how do I only run a certain part of that macro

I thought it would be Application.Run "Book2!Macro1", GoTo Test

Thanks
Pau

 

[Bob Flanagan]

Paul, the best way is to break the called macro up into independent pieces
and then call the one you want. If it is in the same workbook, you can call
a macro just by listing the name of the macro on its own line. No need to
use a Run statement.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

Signature

 

[pauluk]

Bob,

How would i go about this. The macro is in the same module an
workbook