Marlonoire
12-05-2011, 04:34 PM
Hi All,
I'm trying to use a VBA macro to copy the values from a small range of cells (A37:B42) into the Left Box of the header of a worksheet for printing.
I've been successful with a single cell using the following:
Sub UpdateHeader()
ActiveSheet.PageSetup.Leftheader = Range("A1").Value
End Sub
Try as I might I cant seem to find a way to get the values from the range of cells into the header.
Probably very simple, but any help would be appreciated
Thanks
Marlonoire
I'm trying to use a VBA macro to copy the values from a small range of cells (A37:B42) into the Left Box of the header of a worksheet for printing.
I've been successful with a single cell using the following:
Sub UpdateHeader()
ActiveSheet.PageSetup.Leftheader = Range("A1").Value
End Sub
Try as I might I cant seem to find a way to get the values from the range of cells into the header.
Probably very simple, but any help would be appreciated
Thanks
Marlonoire