This site contains a lot of information about speed and memory usage. There
is a download for a measurement tool. I think it has to be paid for.
www.decisionmodels.com
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"John Keith" wrote in message
...
Is there a good source that someone can point me to that will explain or
rank
the various ways that excel can work with data according to how efficient
the
code will work?
I.E. how does =Index(cellarray,match("lookupval",cellarray,0),H1 ) compare
to
Copying the data for cellarray into a sorted cellrange then doing a
vlookup.
Is there an add-in, tool, trick etc. that will observe workbook
recalculations and report on which sets of formula are the resource hogs?
--
Regards,
John