Benchmarking Range to Variant times

  • Thread starter Charles Williams
  • Start date
C

Charles Williams

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top