Coding for header

J

jesmin

Hi There:Thanks in advance.
I am writing a text header at the center of my excel sheet. The tex
will be in 2 lines. I am writing code like:
.CenterHeader = "Monthly Report" & vbCrLf & "For Survey".
But its giving a big gap between the 2 lines. Like:

Monthly Report
 
D

Dave Peterson

I'd try widening the column, then autofitting.

Then autofit the row.

And I'd use vblf instead of vbcrlf (or even vbnewline).
 
Top