Page footer

  • Thread starter Thread starter Ron5440
  • Start date Start date
R

Ron5440

I would like to add the page footer using code.
This is what it looks like using the add footer menu's - Page &[Page] of
&[Pages]
(Page1 of 10).
I have been trying many different possibilities with no luck and cannot find
an example of this same thing here.
Any help is appreciated.
Thanks,
Ron
 
Use this line:

ActiveSheet.PageSetup.RightFooter = "Page &P of &N"

Hope this helps! If so, click "YES" below.
 
Exactly what I needed!
Thanks,
Ron

Ryan H said:
Use this line:

ActiveSheet.PageSetup.RightFooter = "Page &P of &N"

Hope this helps! If so, click "YES" below.
--
Cheers,
Ryan


Ron5440 said:
I would like to add the page footer using code.
This is what it looks like using the add footer menu's - Page &[Page] of
&[Pages]
(Page1 of 10).
I have been trying many different possibilities with no luck and cannot find
an example of this same thing here.
Any help is appreciated.
Thanks,
Ron
Click to expand...
Click to expand...
 
Back
Top