Hello,
I need a exception code for not deleting below content of my packing list.
Let me be clear I wrote below function to clear all unwanted duplicated from my packing list. Unfortunately, some parts has same content as Gross weight and Net weight which below code consider as duplicates and delete it off.
I want some code exception to surpass this content alone. Enclosed spreadsheet which has gross weight content which starts with lots of space as it's imported from a text file.
Need your support please
Sub DeleteRows()
Range("A1").Select
ActiveSheet.Range(Selection, ActiveCell.SpecialCells(xlLastCell)).RemoveDuplicates Columns:=1, Header:=xlYes
End Sub
Bookmarks