Excel Range.RemoveDuplicates Method Count

Posted on 2014-04-12
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.
Question by:canesbr
  • 2
LVL 27

Accepted Solution

MacroShadow earned 500 total points
ID: 39996623
In one word, No.

Author Closing Comment

ID: 39996694
That's 4 words
LVL 27

Expert Comment

ID: 39996710
Ha ha, lol.

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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…

786 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