Writing Fast VBA UDFs - London july19/20

  • Thread starter Charles Williams
  • Start date
C

Charles Williams

I am looking forward to finally meeting many email names in person at the
2006 UK Excel User Conference.

http://www.exceluserconference.com/2006UKEUC.html

For my session on writing fast VBA UDFs I am currently having fun preparing
the examples :

- AVERAGETOL - the slowest version uses Excel/VBA defaults, the fastest is
48 times faster and twice as fast as the equivalent SUMPRODUCT formula.

- FLOOKUP - runs faster than VLOOKUP for everything except approximate
sorted match, for which both FLOOKUP and VLOOKUP are so fast its hard to
tell the difference anyway <g>.

Hope to see many of you there.

Charles Williams
______________________
Decision Models
www.DecisionModels.com
 
C

Charles Williams

Hi Ron,

well holidays are from july through august?
Sorry you wont be there

( I am in trouble anyway since July 19 is my wedding anniversary!)

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com
 

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

Similar Threads

London Excel User Conference 0
UK Excel User Conference - July 19-21, 2006 0
Benchmarking Range to Variant times 0
London Excel User Conference - Register now, it is not too late 0
July 19-21 London Excel User Conference 0
London Excel User Conference - July 19-21 0
Final days for regular registration - London Excel User Conference - July 19-21 0
Last week for regular registration - London Excel User Conference - July 19-21 6

Top