Microsoft Office is really powerful, which is why I use it so much. But using it so much is sometimes quite frustrating!
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
Updated 19th October 2011 at 01:30 PM by Pico