View RSS Feed

It looks like you are trying to write a blog...

I am the data analyst for an independent school. I am mainly concerned with managing and analysing the data held in our MIS (currently CMIS). In my academic tracking work I make extensive use of the CEM baseline data (MidYIS, Yellis and Alis) .

I anticipate that much of this blog will be centred around my use of Microsoft Office and VBA. Since I am in the process of considering a complete re-write of my code and approach, I might even use this blog as a dumping ground for my thoughts on the process.

  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

    Office Agonistes