Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pause Macro
I'd like to pause a macro while the user deletes some rows, then have them
click OK when they're ready to run the insert formulas macro. I looked at some of the solutions here, but wondered what the easiest way is. I'm not using any user forms. TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pause Macro
Hi Cottage6,
Try something like: '============= Public Sub Tester() Dim res As Range On Error Resume Next Set res = Application.InputBox(Prompt:="Select rows to delete", _ Type:=8) On Error GoTo 0 If Not res Is Nothing Then res.EntireRow.Delete End If 'your subsequent code End Sub '<<============= --- Regards, Norman "cottage6" wrote in message ... I'd like to pause a macro while the user deletes some rows, then have them click OK when they're ready to run the insert formulas macro. I looked at some of the solutions here, but wondered what the easiest way is. I'm not using any user forms. TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pause Macro
Brilliant, Norman. Thanks a lot. I've been wondering how to do this for
awhile. "Norman Jones" wrote: Hi Cottage6, Try something like: '============= Public Sub Tester() Dim res As Range On Error Resume Next Set res = Application.InputBox(Prompt:="Select rows to delete", _ Type:=8) On Error GoTo 0 If Not res Is Nothing Then res.EntireRow.Delete End If 'your subsequent code End Sub '<<============= --- Regards, Norman "cottage6" wrote in message ... I'd like to pause a macro while the user deletes some rows, then have them click OK when they're ready to run the insert formulas macro. I looked at some of the solutions here, but wondered what the easiest way is. I'm not using any user forms. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pause a macro | Excel Discussion (Misc queries) | |||
How do I pause a macro? | Excel Discussion (Misc queries) | |||
Pause Macro 2 | Excel Discussion (Misc queries) | |||
Pause a macro? | Excel Programming | |||
Pause during a Macro | Excel Programming |