Hi Guys,

Wondering if someone could help me in developing a simple user interfacing macro. I have a column with dates of a specified range shown below:

dateRange.PNG

The date range can be an arbitrary range so could go from any start date to end date (most of the time its a 6/8 weeks). Lets say for arguments sake the date range goes from 31/12/2014 18:00 to 09/02/2015 18:00 (note date is UK format of dd/mm/yyyy). I would like the user to be asked for a start and end date range that they went - say 01/01/2015 to 31/01/2015. Once they have chosen the range the macro should delete everything BEFORE their selected date range (and shift cells up) and delete everything AFTER their selected date range. The date range is in increments of 10 minutes.

I'm pretty new to the whole User input through InputBox concepts so any advice would be much appreciated! Especially what you do with these input values if you want to use them outside the Sub routine.

Also, it would be EPIC if some fail/error handling was in there - so the macro would revert back to asking them to input the date range again IF
- if they put a date range that is outside the original date range
- if they put in a wrong date format

I'm not asking for a full blown macro, just somewhere to start would be great! Let me know if you need the workbook uploaded.

Cheers.