Benchmarking Range to Variant times
 

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