How do I create Unique headers on every Excel page with VBA?

For each sheet that is printed out I want a different header. For example on
Sheet1 and Page1 it should say monday and on page2, tuesday, etc. Thanks.

I don't believe this is possible in Excel.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jerry Sheldon" <Jerry [email protected]> wrote
in message
news:[email protected]...
> For each sheet that is printed out I want a different header.
> For example on
> Sheet1 and Page1 it should say monday and on page2, tuesday,
> etc. Thanks.

In the following link there are some variants which are close, but not
exactly what I'm looking to do.
http://www.mcgimpsey.com/excel/subs/firstfooter.html

"Chip Pearson" wrote:

> I don't believe this is possible in Excel.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Jerry Sheldon" <Jerry [email protected]> wrote
> in message
> news:[email protected]...
> > For each sheet that is printed out I want a different header.
> > For example on
> > Sheet1 and Page1 it should say monday and on page2, tuesday,
> > etc. Thanks.
>
>
>