Changing the cell selection

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.

Something like the following:

Please Login or Register  to view this content.

it works!!! but now my subroutines don't run properly. Time for some more debugging.