I am using XP-Pro with Office2010 and am having problems with formatting my Header Text when I try to print the worksheet.
I have the following code;
With ActiveSheet.PageSetup
.LeftHeader = "Data as of:" & Chr(10) & vGenDate
.CenterHeader = _
" &B&""Comic Sans MS""&14Supposed to be line 1 &B&""Ariel""&10 Suppose to be line 2 Suppose to be line 3 with " & vGenLoc
end with
The LeftHeader prints fine on two lines as it recognized the carriage return/line feed ( Chr(10) )
I am unable to determine how to write the CenterHeader getting the system to recognize the carriage return/line feed. As written the text comes out with the correct fonts, size, and bold characteristics, but as a single continuous line.
Ideally, someone will respond with the correct syntax so I can write,
With ActiveSheet.PageSetup
.CenterHeader = _
vLine1 & vline2 & vline3
end with
and have all the formatting down in the variables.
THANKS!
I have the following code;
With ActiveSheet.PageSetup
.LeftHeader = "Data as of:" & Chr(10) & vGenDate
.CenterHeader = _
" &B&""Comic Sans MS""&14Supposed to be line 1 &B&""Ariel""&10 Suppose to be line 2 Suppose to be line 3 with " & vGenLoc
end with
The LeftHeader prints fine on two lines as it recognized the carriage return/line feed ( Chr(10) )
I am unable to determine how to write the CenterHeader getting the system to recognize the carriage return/line feed. As written the text comes out with the correct fonts, size, and bold characteristics, but as a single continuous line.
Ideally, someone will respond with the correct syntax so I can write,
With ActiveSheet.PageSetup
.CenterHeader = _
vLine1 & vline2 & vline3
end with
and have all the formatting down in the variables.
THANKS!