How to prevent the error of Unable to get the Match Property of the WorksheetFunction class error?

  • Hi all attached is my code. I would like the program to go back to mainpage( a userform) once its unable to detect a match. Please do advice!

  • Hello,


    Below is a proposal to catch a Match Error



    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)