Delete Rows based on values present in another column

[mlogan]

Hi, I am writing the following code in a button but it is not working for some reason, the code does not generate me an error but it's not doing what it's supposed to do either.

Please Login or Register  to view this content.

I have some values on sheet1 column A and some values on sheet2 column A, I created a button on sheet2 which will look for any matches on sheet1, if found, it should delete the row of the value in that sheet. Pleas note: there are not multiple records with the same value.

Thank you!

[patel45]

your code compares Sheet2 column A with Sheet1 column B
change the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[mlogan]

Thank you, well the columns I was trying to compare are correct, I just restarted the PC and it worked... Sorry for the late reply.