drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 528
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and thanks in advance!
I am using;
But I do not get the Page number on the right footer
I am actually getting :
ActiveSheet.PageSetup.CenterFooter = "&Z&P"
so the route and page within the CenterFooter
So I am actually lost
I am using;
VBA Code:
With ActiveSheet.PageSetup
.LeftHeader = "": .LeftFooter = ""
.CenterHeader = "": .CenterFooter = ""
.RightHeader = "": .RightFooter = ""
Application.PrintCommunication = False
.RightFooter = "&P"
Application.PrintCommunication = True
End With
But I do not get the Page number on the right footer
I am actually getting :
ActiveSheet.PageSetup.CenterFooter = "&Z&P"
so the route and page within the CenterFooter
So I am actually lost