|
Adding Drill-Down Profiler Calls using the Ribbon
You can add drill-down profiler calls to locate slow VBA blocks of code or slow VBA loops.
The recommended way of doing this is to:
Select statements or a procedure (Sub or Function) in the VBE
Then click the “Profile Statements” or “Profile Loops” buttons on the ProfVBA Toolbar in the VBE
.png)
Profile Statements will wrap the selected VBA statements in profiler Start and End calls.
.png)
.png)
Profile Loops will wrap each loop within the selected procedure in Profiler Start and End calls, and will handle nested loops (up to a maximum (default 10) set in Add Profiler Calls).
.png)
.png)
You can repeat these steps to add profiler calls to many different blocks of VBA.
|
