View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default is a variant an object

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