Second Header

[Skydiver]

I would like to add a separate header on page two. Help. I'm using Excel
2000.

 

[Dave F]

When you say a separate header do you mean that you have a header on page
one, and you want something different to appear on page 2?

The best way to do that is to select a print range, print it with the header
you want for that range, and then select another range and print it with the
header you want for that second range.

 

[Skydiver]

Dave,

Thanks for the fast response. Let me explain it a little better.
You're exactly right regarding what I would like to do. I was wondering if
there was a way of just adding a permanent separate second header where I
could automatically print everytime withoug having to set the print area. Is
this possible?

John

 

[Dave F]

Hi John--

I'm not aware of a way to do that.

There may be some VBA programming you can use to do that, but I don't know
what it would be. Maybe post this question in the programming discussion
group and ask if there's a way to programmatically do what you're looking to
do?

Dave

 

[Skydiver]

Thanks Dave.

Hi John--

I'm not aware of a way to do that.

There may be some VBA programming you can use to do that, but I don't know
what it would be. Maybe post this question in the programming discussion
group and ask if there's a way to programmatically do what you're looking to
do?

Dave