Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Understanding the difference
Below are two programs that - to my understanding - are the same. Why does
the first one generate an error message and the second one not? Such small differences (there is a similar thing with the Collection.add function) often incur hours of debugging to me and therefore I would love to understand them. 1st: Dim sums As New Collection Dim colors As New Collection Dim products As New Collection If ExistsInColl(sums, color) Then "do stuff" 2nd: Dim sums, colors, products As New Collection If ExistsInColl(sums, color) Then "do stuff" the function that is called: Public Function ExistsInColl(ByRef col As Collection, ByVal index As String) As Boolean On Error GoTo ErrNotInColl Dim tmp tmp = col(index) ExistsInColl = True Exit Function ErrNotInColl: On Error GoTo 0 ExistsInColl = False End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
understanding of a formula | New Users to Excel | |||
Understanding R1C1 | Excel Programming | |||
Not understanding with/end with | Excel Programming | |||
charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
Not understanding If Not..Then nothing | Excel Programming |