Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Is it more efficient to explicitly search a collection for an entry i.e. : function elementExists(myCollection as collection, myName as string) as boolean elementExists = false for each element in myCollection if element.name = myName elementExists = true exit function end if next end function *OR* whether it is faster/better to use the name as a collection parameter to call an item and catch any exceptions? (I'm not familiar with the code used to implement the latter, but surely it must perform the same kind of operation as the former...?) Thanks all |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Equation Efficiency? | Excel Worksheet Functions | |||
Range efficiency | Excel Worksheet Functions | |||
Runtime error with the sheet collection, which was not there in 20 | Excel Programming | |||
VB Efficiency: Inserting a Row | Excel Programming | |||
.select efficiency | Excel Programming |