Footer on Page Two
 

I have a worksheet that prints on two pages.
How can I get footer on second page only.
I can do it easily in Word, cant seem to figure this out for Excel 2003.

Footer on Page Two
 

One way:

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


In article ,
Pepper wrote:

I have a worksheet that prints on two pages.
How can I get footer on second page only.
I can do it easily in Word, cant seem to figure this out for Excel 2003.

Footer on Page Two
 

Thank you for the feedback.
I am having trouble getting it to work,
having changed the worksheet name in the code to the actual name, and I put
it into the VBA editor ALT+F11, Copy/Paste.
Does it matter if the worksheet of interest is not the only one, nor the
first at the left?

"JE McGimpsey" wrote:

One way:

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


In article ,
Pepper wrote:

I have a worksheet that prints on two pages.
How can I get footer on second page only.
I can do it easily in Word, cant seem to figure this out for Excel 2003.

Footer on Page Two
 

If you entered the correct worksheet name, the position of the sheet or
the number of sheets doesnn't matter.

Since you didn't mention what "trouble" means, it's hard to diagnose it
further.

In article ,
Pepper wrote:

Thank you for the feedback.
I am having trouble getting it to work,
having changed the worksheet name in the code to the actual name, and I put
it into the VBA editor ALT+F11, Copy/Paste.
Does it matter if the worksheet of interest is not the only one, nor the
first at the left?

Footer on Page Two
 

I am sorry, I should have been more specific, you are not a mind reader
I modified the code to read (I pasted the code into the code window of the
VBA Editor)

Dim sFooter As String
With Sheets("survey stats")

Inserted the footer, and it still prints. Survey stats is the sheet name

Thank you very much

"JE McGimpsey" wrote:

If you entered the correct worksheet name, the position of the sheet or
the number of sheets doesnn't matter.

Since you didn't mention what "trouble" means, it's hard to diagnose it
further.

In article ,
Pepper wrote:

Thank you for the feedback.
I am having trouble getting it to work,
having changed the worksheet name in the code to the actual name, and I put
it into the VBA editor ALT+F11, Copy/Paste.
Does it matter if the worksheet of interest is not the only one, nor the
first at the left?