Hi everyone,
I have a macro that will launch an InputBox with the header from the current worksheet as the default text. I have it using:
ThisWorkbook.ActiveSheet.PageSetup.CenterHeader
The problem is that it returns all the formatting garbage like:
&"Times New Roman,Bold"&14ABC Company Report
I just would need it to show just the text - in this case:
ABC Company Report
Is there any property that maybe I'm missing or a different method that regardless of the font properties would return just the text itself?
Thanks for your help.
-- Jim
I have a macro that will launch an InputBox with the header from the current worksheet as the default text. I have it using:
ThisWorkbook.ActiveSheet.PageSetup.CenterHeader
The problem is that it returns all the formatting garbage like:
&"Times New Roman,Bold"&14ABC Company Report
I just would need it to show just the text - in this case:
ABC Company Report
Is there any property that maybe I'm missing or a different method that regardless of the font properties would return just the text itself?
Thanks for your help.
-- Jim