help with header continues

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

ActiveSheet.PageSetup.CenterHeader = "Trend Data for: " &
format(range("C3").value,"mm/dd/yyyy")

In using the above function in vb code, is there a way to have two lines
in the header?
Example
Acme Hospital
Trend Data for 07/21/2003
 
ActiveSheet.PageSetup.CenterHeader = _
"Trend Data for: " & _
VbCr & _
format(range("C3").value,"mm/dd/yyyy")

Regards

Trevor
 
Back
Top