Pause Macro

[Guest]

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

 

[Norman Jones]

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
'<<=============

 

[Guest]

Brilliant, Norman. Thanks a lot. I've been wondering how to do this for
awhile.