VBA: Align text to left in right Excel page header
Posted on 2008-10-30
I'm trying to align text to the left within the right header
With use of vbCR it will be
It looks silly with the default right alignment.
In Excel, the alignment options are grayed out in header set-up.
I've tried: .RightHeader = "&L" & "Michael Bishop" & vbCr &..."
-That puts in the left header.
If there's no direct solution, perhaps there's a tricky round-about solution?
Either would be greatly appreciated.