Small Excel Question Not Worth Its Own Thread

Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread

Zhentar: Sep 28, 2003; Brilliant Master Genius

I don't think inColl does what you think it does.

# ¿ Nov 5, 2010 18:02

Adbot: ADBOT LOVES YOU

# ¿ May 6, 2024 07:30

Zhentar: Sep 28, 2003; Brilliant Master Genius

Yeah.

You want to do something like this:

code:

Function inColl(value As Variant, coll As Collection)
    For Each v In coll
        If value = v Then
            inColl = True
            Exit Function
        End If
    Next
End Function

The Exit Function is just there for efficiency. It could also be an Exit For if you needed to do some processing at the end.

# ¿ Nov 5, 2010 18:47

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread