This exactly what I need to do because I also need to print a border around
my header. But then I also need to print "Page n of t" available in the
Custom Header options. (Each report is going to be 1 to a max of 4 pages.)

Is the a way to do this in VBA code?

Any help would be appreciated!



"David McRitchie" wrote:

You can't put an image into the header until later versions,
and you don't have much control where they print relative
to left and right page margins.

But I wasn't thinking. You can use the top rows of your
spreadsheet as the headers, and draw boxes around what you want.
Would probably only work well if it all fits across one page, you
will have to plan your heading content according to your spreadsheet content.

File, page setup, rows to repeat at top: $1:$4

Headings for Columns, and Page Numbering
http://www.mvps.org/dmcritchie/excel/headcols.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tkaplan" wrote in message
...

you can create the header/footer with the border around it as an image.
in excel you can then insert an image as the header.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=474718