Add in for speed test

[mrichard]

Hi all,

I just rewrote some of my formulas using the LET function and wanted to know how much faster my workbook is.

Does anybody know of a free Excel add in for testing the calculation speed of a workbook?


Thanks
Mark

 

[Fluff]

Have a look here Timing Excel Formula Calculations

 

[Joe4]

Interestingly, a few years ago, MrExcel did a test on the LET function to show the speed differences.
See: Finding VBA Bottlenecks with VBA Profiler

Ironically, it appears he uses the same program Fluff referenced.
It looks like you can download a trial version for free.

 

[Logit]

Or maybe a simpler approach ?

Sub TimeAMacro ()

'The code is below…

'Enter the START TIMER code when you want to start the timer

'-----START TIMER-----
Dim StartTime As Double
Dim TimeTaken As String
StartTime = timer

'Then all your code will go here…

'Then add the END TIMER code when you want to show how long it’s taken.

'------ END TIMER------
TimeTaken = Format((timer - StartTime) / 86400, "hh:mm:ss")

MsgBox "Running time was " & TimeTaken & " (hours, minutes, seconds)"

End Sub

 

[mrichard]

Thanks Fluff and Joe4.

 

[Fluff]

@Logit How will that help timing a formula?

 

[Joe4]

Logit,

Except they are not testing VBA code, they are testing native Excel formula calculation speed.

 

[Fluff]

Thanks Fluff and Joe4.

Glad we could help & thanks for the feedback.

 

[mrichard]

Logit,

I am really not a VBA guy but thanks anyway.