If you use excel Data/ Remove duplicates, after operation it will open a window notifying you how many duplicates and how many deleted. In vba although I have Application.DisplayAlerts = TRUE, the ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes doesn't return anything, although is doing something. How can I make the vba method to open notify window or fill a string with the notify message. Thank you.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel VBA 2007: Remove duplicates - how to get the number of deleted duplicates

Thread starter stevan.dinu
Start date Aug 6, 2009

stevan.dinu

New Member

Aug 6, 2009

If you use excel Data/ Remove duplicates, after operation it will open a window notifying you how many duplicates and how many deleted.
In vba although I have Application.DisplayAlerts = TRUE, the

<code>ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes
doesn't return anything, although is doing something.
How can I make the vba method to open notify window or fill a string with the notify message.

Thank you.
</code></pre>