hello,
I would like to delete duplicate values in a certain range. .Range("B21:I22"). if a duplicate value exists then delete the duplicate value and the one beside it to its left. I have looked at the RemoveDuplicates function but it applies to columns and not specific range or maybe I don't understand it properly. help pls n thank you
regards,
SN
Bookmarks