stevan.dinu
New Member
- Joined
- Jul 11, 2009
- Messages
- 9
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>
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>