View RSS Feed

Office Agonistes

Microsoft Office is really powerful, which is why I use it so much. But using it so much is sometimes quite frustrating!

  1. Excel 2010 - Printer Fails to Communicate

    by , 5th May 2011 at 02:52 PM (It looks like you are trying to write a blog...)
    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 12:30 PM by Pico

    Categories
    Office Agonistes