Please help!
I am in need of some help. I am trying to insert a macro into my Excel sheet that will print a header that is two rows tall. I have used the code below just perfectly to get a header that is one row tall:
I haven't been able to get it to print two rows tall. I have tried Range ("t3:t4"). I have also tried inserting an extra line of code so I have two RightHeader lines. One line has the Range of T3 and one has the Range of T4. But when I do that, it only prints the T4 Range.Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.CenterHeader = "&""Arial,Bold""&18" & Range("c1").Value ActiveSheet.PageSetup.RightHeader = Range("t3").Value ActiveSheet.PageSetup.LeftHeader = Range("e2").Value ActiveSheet.PageSetup.CenterFooter = Range("t2").Value End Sub
I need something that is in Cell t3 to print in the header directly above what is in Cell t4.
Help?
Thanks!
Bookmarks