I want to put cell values into the ge header and then to format heade
text. I have manage to do this using:

With ActiveSheet.PageSetup
.LeftHeader = Range("B52").Value etc

However using this method takes at least 30 seconds for VBA to
set up the page before it will print out. I've tried to use an Excel
macro which I understand is much faster - e.g.:

Application.ExecuteExcel4Macro ("PAGE.SETUP(""&CTEXT"")

This works just putting fixed text into the header, but I have not bee
able to insert the cell value into the header text this way.
There must be a simple solution....

I also wish to format the header text to enlarge and bold it.

Any suggestions?

Pau

--
Message posted from http://www.ExcelForum.com