|
FastExcel VBA Profiling Report
“Show Profiling Report” creates a report worksheet in a separate workbook.
.png)
The report timings are by default exclusive: they show the timed used by a procedure excluding the time taken by the calls from that procedure to other procedures. You can switch to Inclusive timing from the Enable Profiling command.
In this example SetAllExpColors is using 68% of the execution time.
You could then drill-down into SetAllExpColors to see which VBA statements are taking the time.
It turns out that the profile shows that 85% of the time is used turning Screen Updating back on after colouring the cells.
Call Sequence Counts
The Profiler maintains independent calling sequence counts for the first calls to a procedure and the last exit from a procedure. So, if Proc1 is the first Proc and calls Proc2 which then exits and returns to Proc1 which then exits you would get:
|
Proc Name
|
Start Sequence
|
Exit Sequence
|
|
Proc1
|
1
|
2
|
|
Proc2
|
2
|
1
|
Sorting by Start Sequence or Exit Sequence gives a quick way of looking at the starting or ending flow of your procedure calls.
For a more comprehensive trace see FastExcel Trace below.
|
