MattN

slowly getting my head round this....

I'm doing a macro that basically searches for a date. However the date appears more than once.

I can make it perform a search and go in to a loop to find if it's repeated but it always goes in to the debug mode once there are no more to find.

This is what I have:

Do
Cells.FindNext(after:=ActiveCell).Activate
Module1.nextsheet 'this just cuts the line out in to a new spreadsheet
Loop Until ???????

I get the feeling I'm missing something but don't know what.

cheers

matt.