Cell Data Header Only Shows Last Line of Multi-lined Cell Data Header

Hello All,

Below is my VBA code to use for the cell header of my workbook. I would like all sheets, when printed to show the header data below.

Please Login or Register  to view this content.

Unfortunately, the only header data I see is the last line of each alignment. The results are Leftheader=C13, centerheader=C11, and rightheader=Page X of Y.

Can anyone tell me what I'm doing wrong and why I can do to fix this? Idealy I'd like to see the other each data on a new line in the header, for example the left header would be C9, <new line> C13, and so forth.

Any help you guru's out there?

For those of you reading this, I have solved it.

Apparently, only one leftheader/centerheader/rightheader can exist (well it my case at least).

I needed to combine the lines for example, ws.PageSetup.LeftHeader = "TEXT ON FIRST LINE" & Chr(10) & wsT.Range("C9").Value

They key was recongnizing that Chr(10) drops the it into the next line and the & includes more text.

Thanks all.