PC Review


Reply
Thread Tools Rate Thread

Benchmarking Range to Variant times

 
 
Charles Williams
Guest
Posts: n/a
 
      9th Nov 2007
As part of my session at the UK User Group Conference on writing fast VBA
UDFs I am benchmarking the time it takes to transfer data from varying
numbers of Excel cells to a variant.
Time taken looks like a good fit to a constant overhead plus a constant per
cell

If anyone would like to try this on their own system and send me the results
that would be great:
you can download the benchmark tool from
http://www.decisionmodels.com/CambridgeEUC.htm

Charles
_________________________________________
UK Cambridge XL Users Conference 29-30 Nov
http://www.exceluserconference.com/UKEUC.html


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
range and variant Danilo Microsoft Excel Programming 0 26th Jan 2008 03:10 PM
Disconnected Range to Variant =?Utf-8?B?SU5UUDU2?= Microsoft Excel Programming 4 21st Jul 2007 07:00 AM
Assigning range to variant vezerid Microsoft Excel Programming 2 12th Mar 2007 04:46 PM
Assigning range to variant vezerid Microsoft Excel Programming 2 12th Mar 2007 04:45 PM
Type mismatch accessing variant array too many times peter Microsoft Excel Programming 6 12th Feb 2005 10:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:48 AM.