Recent Blogs Posts

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 ...