Speedy Page Setup

Submitted by Juan Pablo González of Bogotá, Colombia. Juan Pablo is the developer of the F&I Menu Wizard and handles all Spanish programming requests at MrExcel.com.

The following examples compare the runtimes of variations on changing the margins from the defaults to 1.5" and the footer/header to 1" in the Page Setup. The macro recorder was used to create Macro1. Macros 2, 3, and 4 show how the recorded code's runtime can be decreased. Figure 13.9 shows the results of the speed test running each variation:

Figure 13.9

Page setup speed tests.

0 0

Post a comment