View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default is a variant an object

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