Ron deBruin has some code to get you started:
http://www.rondebruin.nl/print.htm#Header

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

victoria wrote:

I am preparing a worksheet with a custom header for the first page. Under
the header I have column titles that I would like to appear on the second
page of my worksheet. How do I keep the column titles but delete the custom
header from the second page.

--

Dave Peterson