Delete rows based on two specific dates using a input box

Hi Guys,

I have become unstuck and I desperately need you assistance once again :-)

I need a VBA code that will do the following:-

I have a data set, Row 1 contains table headers which will never change, column A contains dates (in UK Format dd/mm/yyyy) the list of dates will change daily I.e currently displays Jan 2018 - December 2018. Columns B - E contain the data.

I want the VBA code to delete rows if the data falls between two date ranges located in column A.

For example, with the current data I have a number of rows with data that falls in December 2018. I want to delete these rows out of the data set

The code needs to be dynamic enough in a sense that I can change the dates to delete the rows by using a input box


Any help as ever will much appreciated


Slosh x

At a simple search you can find a lot of solutions to your problem. See here an example:

https://www.ozgrid.com/forum/forum/h...ide-date-range

Hi thanks for the heads up,

from the link the below code works and I like it, but.....

It doesn't pull in all the rows for the specific dates?

i.e. when prompted by the input box, enter 15/05/2018 for both start and finish and only 41 rows are left after deleting everything else that sits outside this date range. However there are 73 rows of information that contains the 15th May 2018 in column A not 41 ?

Please Login or Register  to view this content.

any ideas ?


Thanks

Slosh

I've tested and it works for me. Maybe those are not 15th May dates? You can upload a sample, otherwise we can just guess.

Try change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

This line of code worked but the required results didnt happen

Please Login or Register  to view this content.

please see attached workbook for example


Thanks again guys for you help


Slosh

Change to:

If .Cells(i, "A").Value >= dteStart And .Cells(i, "A").Value < (dteEnd +1)Then

@phuocam absolute GENIUS !!!!!

Worked a treat my friend

very much appreciated for your time and willingness to help from the other side of the world !!!

#power to the people

Slosh x

You're welcome!