Hi TheThanks in advance.
I am writing a text header at the center of my excel sheet. The text
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