| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start Macro / Stop Macro / Restart Macro
1) How can I start a macro to preform normal functions(ie
cut-copy-paste). Stop the macro in mid stream to adjust specific formulas and then resart the macro to preform the rest of the macro? Any help is greatly appreciated. Pete |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start Macro / Stop Macro / Restart Macro
Pete,
Not sure what you want to adjust mid stream in your macro but take a look at "Input Box" in the VBA Help. John Pete wrote: 1) How can I start a macro to preform normal functions(ie cut-copy-paste). Stop the macro in mid stream to adjust specific formulas and then resart the macro to preform the rest of the macro? Any help is greatly appreciated. Pete |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start Macro / Stop Macro / Restart Macro
You can't. You need to break the macro into two pieces. Execute the first,
do the adjustments, execute the second. Regards, Tom Ogilvy "Pete" wrote in message ... 1) How can I start a macro to preform normal functions(ie cut-copy-paste). Stop the macro in mid stream to adjust specific formulas and then resart the macro to preform the rest of the macro? Any help is greatly appreciated. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
| How to start a Macro | Excel Discussion (Misc queries) | |||
| Start/Stop Macro Button | Excel Discussion (Misc queries) | |||
| how to stop/ restart macro after selecting from autofilter list | Excel Discussion (Misc queries) | |||
| Can I break and restart a link in a macro | Excel Worksheet Functions | |||
![Pete[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
