Long term users of Excel VBA will be familiar with slow processing of page set up if code like the following is used:
With ActiveWorksheet.PageSetup
.CenterHeader = "Title of the Worksheet"
.LeftFooter = "Today's Date"
.RightFooter = "Page &P of &N"
.PrintArea = "$A$1:$H$28"
End With
The problem with the code is that, despite the use of the With statement, each line requires a call to the printer driver, rather than the whole statement being sent once. The most commo
