D
dollinger64
I would like use VBA to insert a range of cells as the header from a
sheet named head. I do not want to use the titles under the print
setup to print the rows above the spreadsheet since the row widths in
the header do not match the rows in the spreadsheet. The header
contains a picture (company logo). Can this be done with VBA or is
there another way to resolve the width issue. I tried this below but
it does not work. It only inserts the A1 cell. Thanks
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader =
Sheets("head").Range("A1:L15").value
End Sub
sheet named head. I do not want to use the titles under the print
setup to print the rows above the spreadsheet since the row widths in
the header do not match the rows in the spreadsheet. The header
contains a picture (company logo). Can this be done with VBA or is
there another way to resolve the width issue. I tried this below but
it does not work. It only inserts the A1 cell. Thanks
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader =
Sheets("head").Range("A1:L15").value
End Sub