An elegant way to delete a complete row based on time value in cell

Hello,

I have a spreadsheet with date and time values of the format
"dd/mm/yyyy hh:mm" in column A followed by some other data in cells of that row.

What I'd like to do is have a macro that will delete a complete row if the time value in column A lies between two times that I can specify in the macro (the dates are irrelvant)

I was wondering if anyone knew of an elegant solution to this problem.

Many thanks in advance,
twills

How's this work for you?

Please Login or Register  to view this content.

Make sure the A column is formatted as a date.

I think that doesn't ignore the date, Dave.

Please Login or Register  to view this content.

I'm sorry, I read the problem wrong. Thanks for picking up my slack shg.

Please Login or Register  to view this content.

Well, in shg's code the first cell processed is actually the last cell in in the column. Are you saying you want to work from the top down, or are you saying you only want to go from row 5 to the bottom row?

If its the latter case, the code that says which rows is:

Please Login or Register  to view this content.

This says "start at the bottom row and check each row up to the top row."
To only check each row up to the fifth row, change like this:

Please Login or Register  to view this content.

Note it will not run properly if you have less than 5 rows.