Macro speed monitoring

[Marq]

Can anyone recommend a utility that will analyse/monitor the speed of m
Excel 97 VBA code.

Having performed the standard speed optimisation tricks (scree
updating, cell referencing, select and with statements, etc) I am stil
looking at wanting to improve the overall code performance.

Therefore a utility which indicated the time taken by each function/su
and the number of times it was called would be handy.

Thanks
Mar

 

[Bob Phillips]

Marq,

That is then down to design.

Look at your design and see if there are any pressure points. Can't see a
utility being much help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)