AAP Member Sep 21, 2016 #1 Hello, Is there any way to check that vba method Range.RemoveDuplicates actually found some duplicates from the data or not?
Hello, Is there any way to check that vba method Range.RemoveDuplicates actually found some duplicates from the data or not?
Chihiro Excel Ninja Sep 21, 2016 #2 No there isn't. At least not directly. Just do count of rows before and after you use the method to remove duplicates.
No there isn't. At least not directly. Just do count of rows before and after you use the method to remove duplicates.
AAP Member Sep 21, 2016 #3 Chihiro said: No there isn't. At least not directly. Just do count of rows before and after you use the method to remove duplicates. Click to expand... Many Thanks! Have a nice day.
Chihiro said: No there isn't. At least not directly. Just do count of rows before and after you use the method to remove duplicates. Click to expand... Many Thanks! Have a nice day.