LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Variant/Double?!? PeterArvidsson Excel Programming 6 May 31st 06 04:50 PM
Variant owl527[_5_] Excel Programming 2 October 14th 05 09:37 PM
ReDim Object array as parameter of Variant array Peter T Excel Programming 4 May 10th 05 02:11 PM
IsArray on Variant/Object/Range returns true?? QuantDev Excel Programming 10 July 28th 04 02:51 PM
Argument can be a variant or an object onedaywhen Excel Programming 1 September 25th 03 04:20 PM


All times are GMT +1. The time now is 02:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"