"New line" in footer with pagesetupfooter

[matko]

Hello, please I have a problem with adding more lines into footer using pagesetupfooter. Does onyone know what special character can I use for new line in footer text?

ActiveSheet.PageSetup.LeftFooter='Text in First line'+'\N '+'Text In Second Line'

But \N does not work.
Any Ideas?

Thanks a lot for replies

Martin

 

[VoG]

Hello and welcome to MrExcel.

Try

ActiveSheet.PageSetup.LeftFooter = "Text in First line" & vbCrLf & "Text In Second Line"

 

[matko]

Hello, thank you.
I have a problem that i am not using VB. I am using only OCX for comunication between Navision and Excel. So that's why i need some character in a text.

Martin