Hello,
I have the following code
That works fine, but together with duplicates removes and the formating. Is it a way to keep the formating?
Thank you
I have the following code
VBA Code:
Sub Remove_Duplicates()
' Clear Duplicate Entries from Sheet - Proforma
Worksheets("PROFORMA DRYHIRE").Range("A15:C70").RemoveDuplicates Columns:=1, Header:=xlYes
MsgBox "Duplicates Removed!"
End Sub
That works fine, but together with duplicates removes and the formating. Is it a way to keep the formating?
Thank you