Macro to add title in header is missing text once macro is run
Hi, I have created a macro to format a spreadsheet, including adding a title in the header. One of the fields 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 attachment. Why might this be happening and how would I correct this? Thanks in advance!
|