Pausing a MACRO

I want to create a Macro that allows me to pause the Macro for a user input.
Specifically what I need to do is have the Macro start by asking the user to "select a range" ( hence the pause) then the Macro will copy that range, paste into another range where some formulas work on the data creating a data array, sort the array, select the print area, and then print the data as a certification form.

The only thing I can't do is get the Macro to start by asking for a range to be selected and resume.

Any ideas?? Thanks --mark

Hi

Use the application.inputbox approach.

Set myrng = Application.InputBox(prompt:="Select range", Type:=8)
  MsgBox myrng.Address

If you run the code above, it will ask you to select a range. Use the mouse to select a range, then continue.


HTH

rylo

That pretty much did the trick. I had to modify some but you got me pointed the right direction -- Thanks!