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

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

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/

Bob,

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

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