austenr
05-25-2005, 07:45 AM
I am trying to use a range of cells to use in the header on Sheet2. However, using the code below I only cet cell C1. Does anyone know why or is there a way to use a range of cells in a header?
Worksheets("Sheet2").PageSetup.LeftHeader = _
Worksheets("Sheet1").Range("C1:E1")
Worksheets("Sheet2").PageSetup.LeftHeader = _
Worksheets("Sheet1").Range("C1:E1")