Hi Guys,
I'm new to this forum and I'm trying to accelerate on VBA after start learning it. May I kindly ask some help? Anybody had any suggestions how to remove duplicated rows with VBA i.e. related coding
Thank you in advance!
Gergely
Hi Guys,
I'm new to this forum and I'm trying to accelerate on VBA after start learning it. May I kindly ask some help? Anybody had any suggestions how to remove duplicated rows with VBA i.e. related coding
Thank you in advance!
Gergely
Hi,
Why do you need VBA to do this?
It is already there under Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates
A sample code to remove duplicates comparing multiple columns
Sub RemoveDups_MultColumns() ActiveSheet.UsedRange.RemoveDuplicates Columns:=Array(1, 2) , Header:=xlYes End Sub