Run time error type mismatch 13

[Dariusd7]

getting this run time error 13 type mismatch


here is the code

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[HaHoBe]

Hi, Dariusd7,

if you start at the first row a match is found and 0 is given to a row nunber (which is not available and will cause thee runtime error).

Please Login or Register  to view this content.

Ciao,
Holger

[stnkynts]

Putting in this little check lets you know what the problem is:

Please Login or Register  to view this content.

LastRowOnes is = 0. You can't select a row 0. The problem is occuring in your loop.