Solved

Excel Range.RemoveDuplicates Method Count

Posted on 2014-04-12
3
342 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
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
MacroShadow earned 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
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…

680 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