Hi Experts,
I need to clear (not delete) rows in column range A:EH based on in row duplicates in column A. I use this formula to find the duplicate column A values =COUNTIF($A$1:A1,A1)>1 but I need to clear the contents of the duplicate rows in column range A to EH.
I found the RemoveDuplicates function and the following code which completes the correct selection but deletes the range rather than clearing it.
Is anyone aware of a function that will do the same but clear the rows instead of deleting them?
Thanks if you can help!
regards
Mark
I need to clear (not delete) rows in column range A:EH based on in row duplicates in column A. I use this formula to find the duplicate column A values =COUNTIF($A$1:A1,A1)>1 but I need to clear the contents of the duplicate rows in column range A to EH.
I found the RemoveDuplicates function and the following code which completes the correct selection but deletes the range rather than clearing it.
VBA Code:
Sub Remove_Duplicates()
Range("A1:EH99").RemoveDuplicates Columns:=1, Header:=xlYes
End Sub
Is anyone aware of a function that will do the same but clear the rows instead of deleting them?
Thanks if you can help!
regards
Mark