Hi all,
I have a problem with macro - I need it to remove duplicated lines in columns A-D, starting from row 4. I want it to remove only duplicated lines, so data in column A-D is the same as somewhere else.
Any ideas how to fix it?
I have a problem with macro - I need it to remove duplicated lines in columns A-D, starting from row 4. I want it to remove only duplicated lines, so data in column A-D is the same as somewhere else.
Any ideas how to fix it?
VBA Code:
Dim LastRowZVOL As Integer
LastRowZVOL = Worksheets("LSMW ZVOL MATERIAL").Cells(Rows.Count, 1).End(xlUp).Row
Worksheets("LSMW ZVOL MATERIAL").range("A4:D" & LastRowZVOL).RemoveDuplicates Columns:=Array(1, 4)