Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default If value occurs more than once then delete all of them

Yeah, it's a bit of a joint effort by a few others that helped out with
the coding so it was/is as optimized as possible. The file has 50K
values but in Excel12 and later it can setup 500K if you want to test
against larger amounts of data.

I didn't use any on sheet controls because I normally just run from the
macros dialog (Alt+F8) with macros for ThisWorkbook selected.

--
-
Garry

Free Usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
if number occurs twice ekkeindoha Excel Discussion (Misc queries) 1 September 25th 07 12:14 PM
How to calculate the Date occurs Blue Fish Excel Worksheet Functions 2 July 26th 07 10:42 AM
MsgBox when an Error occurs Vick Excel Discussion (Misc queries) 1 December 21st 05 08:48 PM
How can I add up how often certain text occurs? Martin M Excel Worksheet Functions 3 June 17th 05 10:00 PM
Counting times a value occurs Jordan Excel Programming 1 May 6th 05 06:44 PM


All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"