I have a command button and when I click on it I want it to run a subroutine.

The sub routine will disregard the active cell and let the user select a new range of cells in the worksheet.

I know you can select specified cells (A1:D4), but I want to have the user select a new active cell and range.