Excel 2007 VBA - Multiple line header adds empty line in between

Dear all,

In Word, you can easily have a header which is two or three lines (rows in Excel terms). However, I seem unable to do the same in Excel as a VBA command or even directly into the LeftHeader from Page Layout view.

I have used the following code:

Please Login or Register  to view this content.

Retrieving the input data for the header from another sheet works fine. FYI, the same problem occurs for the footer. I have a feeling it has to do with the vbNewLine command, but don't know for sure.

If you delete the empty line from the normal Excel view, it automatically updates it again with a blank line in between.

Hope someone can help, thanks,

Chris

I found that if I delete the code from VBA and manually enter the header it does work. Is this something I just have to accept?

Thanks, that's worked a charm!