ruuning part of a macro from another macro

P

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
 
B

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
 
Top