formatting headers
Hi
I know that sheet1.pagesetup.centerheader = "&""ariel,bold""&12HELLO" puts HELLO in the header and formats it to bold and font size 12. How do I replace the HELLO with a variable, as on my spreadsheet the header is a date variable that is changed just prior to the sheet being printed? All help much appreciated |
All times are GMT +1. The time now is 01:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com