cookeetree
Board Regular
- Joined
- Mar 2, 2015
- Messages
- 52
G'day Excel Gods,
I have a macro that has been running fine, until today. The macro copies a worksheet into a new file, pastes the values to remove formulas, then sets up print parameters and prints the new file.
This line...
.LeftFooter = "Signatory ................................................ Date: " & Date & " J. Smith"
...simply creates a footer with today's date and the signatory's name.
As of today, instead of printing today's date, it prints 13/09/2023 and instead of J. Smith, it prints the previous signatory's name.
The most bizarre thing is that, if the macro is run a second time, it works perfectly!
Any help you could provide would be much appreciated.
Cheers, Jason.
I have a macro that has been running fine, until today. The macro copies a worksheet into a new file, pastes the values to remove formulas, then sets up print parameters and prints the new file.
This line...
.LeftFooter = "Signatory ................................................ Date: " & Date & " J. Smith"
...simply creates a footer with today's date and the signatory's name.
As of today, instead of printing today's date, it prints 13/09/2023 and instead of J. Smith, it prints the previous signatory's name.
The most bizarre thing is that, if the macro is run a second time, it works perfectly!
Any help you could provide would be much appreciated.
Cheers, Jason.