Macro to add title in header is missing text once macro is run
Hi experts,
I have created a macro to format a spreadsheet, including adding a title in the header. After to macro is run, the text in the header is incomplete, even though in VBA it appears as it should. Specifically, the word "REPORT" finishes as "RE" when the macro is run. Please see my attachments. Why might this be happening and how would I correct this? Thanks in advance
|