Im using the following code to remove duplicate records from a sheet:
It successfully removes the duplicates (based on Columns A and B), however it is changing the formatting of the cells and messing with the conditional formatting I have on the sheet. How can I get around this?![]()
Sub DuplicateDelete() With Sheets("EquipmentData") lastrow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Range("$A$3:$B$" & lastrow).RemoveDuplicates Columns:=Array(1, 2) End With End Sub
Bookmarks