Quote Originally Posted by Norie View Post
3 Declaring it as Variant won't solve the problem but it will help with it.

A Variant can be of any data type, even an error, so if the Match fails you won't get a run-time error but you can check, with IsError, MatB.

4 When I declare as Variant and use Application.Match there's no run-time error but MatB does contain an error value.

5 Not sure what you mean there.

As for there being no more data, if that's the case the Match will fail every time.
I know i´ve marked as solved and therefore i should not write in here anymore but i feel like this rly needs clarification:

5) if you checked on the conditions just below the variable declaration there is a matB <>0 and matb =0 which is the case where i´m counting on default value of 0

and as for the last statement it wont fail, cause the data where it should match will be created before the match function will be triggered....you run the userforms, you create a list of criteria in which the match function gonna look for repetitions