If duplicates found then don't run macro

  • Hi,
    I have numeric data in sheet4.range(A1:A)
    I have also numeric data in sheet4.range(A1:A)


    If with both range found duplicate data then don't run code and warn me with the help of msg box


    If duplicate not found then run the code,


    Thanx alot

  • Re: If duplicates found then don't run macro


    Hi haroon2015,


    Try this:



    Regards,


    Robert

  • Re: If duplicates found then don't run macro


    How many rows do you have as it was fast for me?


    See if this makes a difference:


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!