Delete merged rows

[fatalcore]

Hi,
I am stuch with this problem,What I want is a VBA code against the button "Delete" in the sheet "Metal" that,
if in the sheet "Face" the value in the column AL is 0 then the entire row will be deleted in the "Metal" sheet.
The values in Column J in "Face" and Column F in the sheet "Metal" is unique.That is Test1,Test2,Test3 etc..
I am uploading a dummy sheet for reference.
Thanks in advance.

[arlu1201]

So should the values in column J in "Face" and column F in "Metal" be matched and then the value in column AL checked and then the corresponding row in Sheet Metal to be deleted?

[fatalcore]

Hi arlu1201,
Yes, you are absolutely right about it. If the value in AL = 0 then only the row in Sheet "Metal" will be deleted.
Thanks in advance.

[Leith Ross]

Hello fatalcore,

Here is the code for the two macros that appear in the attached workbook.

Command Button Code

Please Login or Register  to view this content.

Module1 Code to Delete the Rows

Please Login or Register  to view this content.

[fatalcore]

Hi,Leith Ross

Thanks for your reply, can u please modify the code a little bit so that the range is not fixed like test2 only. I want it for Test1, Test2 and Test3 also.
Thanks in advance.

[Leith Ross]

Hello fatalcore,

Sorry, I forgot to remove "test2" from the Find operation. The value to find is passed in as as string. The code should be as below...

Please Login or Register  to view this content.

[fatalcore]

Thanks mate