header and footer on every page except the first page?

[marany]

how do i put header and footer on every page except the first page?

[JE McGimpsey]

One way:

http://mcgimpsey.com/excel/subs/firstfooter.html


In article <EBE1E559-C27E-47F9-BA16-0AA05EE9352E@microsoft.com>,
marany <marany@discussions.microsoft.com> wrote:

> how do i put header and footer on every page except the first page?

[bandbrocks]

Thank you for the link to your website!

When I automate this feature, the selected worksheet prints out two times. The first time the first page has a different header and the remaining pages have the original header. The second time, all the pages print out with the original header.

Is there a way to keep Excel from printing the secind time? I am using Excel 2003 and Visual Basic 6.3.

One way:

http://mcgimpsey.com/excel/subs/firstfooter.html


In article <EBE1E559-C27E-47F9-BA16-0AA05EE9352E@microsoft.com>,
marany <marany@discussions.microsoft.com> wrote:

> how do i put header and footer on every page except the first page?

[bandbrocks]

Does anyone have any experience with this issue?

Thanks!