Dan Wilson
Well-known Member
- Joined
- Feb 5, 2006
- Messages
- 546
- Office Version
- 365
- Platform
- Windows
Good day. I am running Office 365 on Windows 10 Home. I have a workbook with seven worksheets, each having a Header. I have several Macros, each one producing a different version of the data on a worksheet. In each Macro there is the following:
The code continues on. When I print out a particular sort, the Center Header prints Speedway Chapter 3399 & Rides 2019. When I edit the Header, it shows Rides 2019. What am I doing wrong? Do I need to remove the Header that I entered manually? Any help is appreciated.
Thank you,
Dan Wilson...
Code:
Application.PrintCommunication = False
With ActiveSheet.PageSetup
.LeftHeader = "Printed on &D"
.CenterHeader = "Speedway Chapter 3399" & Chr(10) & "Rides 2020"
.RightHeader = "Page &P of &N" & Chr(10) & "Ride Totals"
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
Thank you,
Dan Wilson...
Last edited by a moderator: