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.