Re: Filtering Column Duplicates

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: keepITcool (xrrcvgpbby_at_puryyb.ay)
Date: 01/26/05 

Date: Wed, 26 Jan 2005 13:00:03 -0800

Craig,

Anomaly is in fact a programming error, causing the last item added to
the dictionary to be discarded in the writeback to the array.

line For n = 1 To .Count - 1
s/b For n = 1 To .Count

Re latebound:
good to see you've done a bit of homework, and understood.
I'll rephrase what I thought obvious, but apparently wasn't...

add reference to Microsoft Scripting Runtime

line dim oDic as Object
s/b dim oDic as Dictionary

line set oDic = CreateObject(etc)
s/b set oDic = new dictionary

ofcourse changing the 0 (back) to TextCompare is not needed,
but may make the code easier to read.

HTH 

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam
Craig Freeman wrote :
> keepITcool,
> 
> Cool...that did the trick.
> 
> Interestingly enough, the same anomalies that I commented on with
> Tom's modified code, also appeared with your suggestion..?  I'd like
> to understand why this is..? The workaround seems to be adding an
> erroneous row of data at the end of the worksheet.
> 
> > You'll have better performance with the early bound variant,
> > by adding the reference, and swapping the commented lines.
> > for DIM and SET
> 
> Sorry, I'm very new to this game and still learning.  I've read that
> 'Late-bound' means that the interface is not known at compile time,
> and that 'Early-bound' is known at compile time - and as you stated,
> this increases performance.  Kinda of like stating a fact before the
> question is asked.  What I'm not sure of, is the adding the reference
> part and which commented lines for DIM and SET to switch.  Apologies
> if this is obvious.
> 
> thanks again,
> Craig Freeman

Relevant Pages

  • Re: Which patches to install for Oracle 9i R2 (9.2.0.4.0) on 11i (11.11)?
    ... > Which patches should I install? ... Subject: Oracle RDBMS on AIX,HP-UX,Solaris,Tru64,Linux,MacOSX: Versions, Sizes, Requirements Quick Reference ... PHCO_28427 s/b PHCO_29029 s/b PHCO_31903 ...
    (comp.sys.hp.hpux)
  • Re: Newsgroup Opinion
    ... S/B 954RR wrote: ... "Steve Robbins" wrote in message ... Where did Mitchell go? ... The Unofficial a.s.b.b-r Reference Page ...
    (alt.sports.baseball.bos-redsox)