I'm Looking For Help Again

[bloubul]

Hi All

Attached are part of my 7_49 Database. In it there is a macro that looks at all the cells in the database when I insert the previous draw numbers and if it find similar cells in the database it put in on Sheet "Rowes", the current out put is in column "A" of the "Rowes" sheet, but I want the macro to give me the cells it find and the count of correct numbers in those cells as indicated in columns "E:F" in the "Rowes" sheet.
The macro must be able to look for 3, 4, 5, 6, and 7 numbers, the current macro can't look for more than 3 numbers.
Here are the link: http://www.mediafire.com/file/yitrsmj9vkw0w0k/Russia_749_Database1..xlsm/file

I trust that I have explain myself fully and correctly.

BlouBul

 

[time*treat]

I left most of your orig code in, as '' comments, so you could see what I changed.
The 'If Len(c.Value) = 20' section breaks when the values don't show up in the order it's expecting them.


http://www.mediafire.com/file/tebipy55zpatjla/tt_Russia_749.xls/file

 

[bloubul]

time*treat

Thanks friend it works good.

BlouBul