?
Solved

Excel Range.RemoveDuplicates Method Count

Posted on 2014-04-12
3
Medium Priority
?
355 Views
Last Modified: 2014-04-12
When removing duplicates in the Excel sheet Ribbon>Date>Date Tools>Remove Duplicates you get a message as to how many duplicates were removed.
Does the VBA Method provide this somewhere? How to you retrieve the count when using the VBA Range.RemoveDuplicates method?
I know there are countless ways for determining this number, my question is whether is is available using this method.
Regards
Brian
0
Comment
Question by:canesbr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
MacroShadow earned 2000 total points
ID: 39996623
In one word, No.
0
 

Author Closing Comment

by:canesbr
ID: 39996694
That's 4 words
Regards
Brian
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39996710
Ha ha, lol.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question