help with header continues

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
 
T

Trevor Shuttleworth

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

Regards

Trevor
 
Top