Hi

I have the following code
HTML Code: 
which is supposed to look in column a for a date, if appropriate date is found it is supposed to copy that row and paste it into a seperate sheet.

This works fine to a point but once its found two or three occurances it stops looking and I have to run the macro again.

Any ideas why it doesn't keep looping until it finds all the occurances.

Any help appreciated