Problem with cell.Find

Hi,

I wrote the following code to perform an operation like... It should search the entire workbook and find the records matches with the given date (iDate_Key), also all the found rows should be copied to another sheet.

But when I am running the following code, only the first row (with the date match) is getting copied.

Please help...
________________________________

Please Login or Register  to view this content.

Have a look at FindNext - You need to set a pointer to the first match, process that match, then find the next match. You keep invoking this until you have come back to the very first match you find then break the loop.

Please Login or Register  to view this content.