vba .findnext gives 'nothing'

Hi,

I have made this small macro which should lookup 'sku' in worksheet 'Thistv' and write the 'number' found at the 10th column of the same row to the cell at worksheet 'Tvad' in a matrix at the cell corresponding with 'sku' and 'day'. 'day' can be found in the 8th column of the worksheet 'Thistv'.

Please Login or Register  to view this content.

I get problems in the line in bold, because it does not find a next value, although there are still a lot of matches,
I think the problem is situated in the lines before, where I go first to an other worksheet, and then the method .findnext doesn't work anymore,
any suggestions? Thanks a lot!