Filtr and delete Rows Between 2 times

[saram1989]

HI Guys

I already have a VBA for some of work,
basically

It copies the sheet to a new tab, Renames it an then removes all rows tat has a "c" It also Adds a new column an calculates the cycle time
I would now if possible delete all rows that are less than '00:10:00' and greater than '02:00:00'
My column however is all calculated by formula.

[PaulSP8]

Try changing your code to;

Please Login or Register  to view this content.

Remove the "=" if 00:10:00 and 02:00:00 are actually allowed

[saram1989]

Thanks for this

However currently my code removes the rows that contain anything with "C" in column C before adding the new column (I) and then calculating the times in this column,

Column I is the column I need to delete the row fro between these time

Thank you

[saram1989]

Totally get this version now, thank you worked a Treat.
Totally make sense to ad the columns and workings a then delete everthing I don't need after
Thank you much for your quick help.

[PaulSP8]

However currently my code removes the rows that contain anything with "C" in column C before adding the new column (I) and then calculating the times in this column,

I caught that and amended the code it do Col I before the loop, does it work now?

Please Login or Register  to view this content.