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
Bookmarks