User to select a range for deletion

J

jimbo

I would like in to include in a VBA macro to stop after it's last command and
allow a user to select a un pretermined range for deletion and for the macro
to delete that range and either to restart the macro to continue with it's
next command or alternatively to stop.
 
J

jimbo

--
hopalong


Gary''s Student said:
Do you want to shift the remaining cells up or to the left??
exactly were they are are. If the user selects the range for deletion and
wishes to stop the macro The macro could end by returning the cursor to Cell
A1. If the user prefers to continue with the macro after deleting the range
then I would like the user to choose that option.I presume that this could be
done via a message box solution?

Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top