Page footer

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
 
R

Ryan H

Use this line:

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

Hope this helps! If so, click "YES" below.
 
R

Ron5440

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting the date from my left footer 3
Need help with a Macro or VB code for Header/Footer 6
Custom Footer 2
Auto height adjustment to fit on a single printed page 2
Report Footer 1
Capturing web page load times from VBA 3
header/footer different first page 1
Format page number in Words Document 1

Top