|
Show Profiling Report
.png)
The profiling report is created as a worksheet called FastXLProfVBAn in a separate workbook.
.png)
The report timings shown are exclusive: they show the timed used by a procedure excluding the time taken by the calls from that procedure to other procedures. When using the Inclusive setting the time taken by the calls for a procedure will include both the time taken by the procedure itself and the time taken by all the procedures it has called.
In this example SetAllExpColors is using 22% of the execution time. To drill down into that procedure, “Remove Profiler Calls” then “Add Profiler Calls” for SetAllExpColors using either the Nth line option or the Profile Selected Statements option or one of the Profile Loops options.
For ease of use Profile Statements and profile Loops can be used from within the VBE and act on the VBE selected statements or procedure.
It turns out that in this case the profile shows that 85% of the time used in SetAllExpColors is turning Screen Updating back on after colouring the cells.
Call Sequence Counts
The Profiler maintains independent calling sequence counts for the first entry call 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.
|
