Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coding for header
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coding for header
I'd try widening the column, then autofitting.
Then autofit the row. And I'd use vblf instead of vbcrlf (or even vbnewline). jesmin wrote: 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 For Survey How can I delete this gap and can have a header that will look. Monthly Report For Survey -Appreciate VBA help. --Thanks in advance -- jesmin ------------------------------------------------------------------------ jesmin's Profile: http://www.excelforum.com/member.php...o&userid=29540 View this thread: http://www.excelforum.com/showthread...hreadid=494843 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Questions concerning VBA coding | Excel Discussion (Misc queries) | |||
Color coding the excel sheets | Excel Discussion (Misc queries) | |||
color coding custom number formats | Excel Discussion (Misc queries) | |||
User Form Coding | Excel Discussion (Misc queries) | |||
Hidding Macro names and coding | Excel Discussion (Misc queries) |