Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That's true.
I have a love-hate relationship with Variants. I was leary of using them at first -- I didn't like the concept, nor the system overhead, but they sure make programming easy. And I can make more versatile functions using them as args. "Jim Thomlinson" wrote: A variant is anything it wants to be. It can be an object (requiring the set statement), or it can be a regular variable (not requiring the set satement) as pointed out by Charlie... That being said try not to use varaints as much as possible. They are very inefficient, because everytime that you try to access a variant, the system must first try to determine exactly what it is... This is a relatively slow process... -- HTH... Jim Thomlinson "James Cornthwaite" wrote: does when assigning a variant need a set statement? THanks James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Variant/Double?!? | Excel Programming | |||
Variant | Excel Programming | |||
ReDim Object array as parameter of Variant array | Excel Programming | |||
IsArray on Variant/Object/Range returns true?? | Excel Programming | |||
Argument can be a variant or an object | Excel Programming |