Thread: Pausing a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alex.W Alex.W is offline
external usenet poster
 
Posts: 24
Default Pausing a macro

I am trying to develop a macro that deletes a row of data after pausing for
input.

I need a message that asks if they want to delete. If no, quit. If yes,
pause and ask for the cell at the start of the row to be selected.

Once selected, how is the macro re-activated?

If any column other than "A" is selected I need an error message.
If cell "A5" is selected I also need an error message.

I then need the macro to select the 9 cells to the right (in the same row)
of the one selected. This range is then deleted.

Alex.W