Solved

Excel Range.RemoveDuplicates Method Count

Posted on 2014-04-12
3
347 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 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

 Database Backup and Recovery Best Practices

Join Percona’s, Architect, Manjot Singh as he presents Database Backup and Recovery Best Practices (with a Focus on MySQL) on Thursday, July 27, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). In the case of a failure, do you know how long it will take to restore your database?

Question has a verified solution.

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

A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.

623 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