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 " wrote in message
...
Hi All,

Just a little help please,

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

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

Thanks
Paul


---
Message posted from http://www.ExcelForum.com/