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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find highest value in a specific data set. 6
counting records by month and year / date format issues 1
help with header 2
VBA for Date custom Filter 3
paste row into Sheet2 in next row 1
hard slope question 2
Looking up text value version from today() 5
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2

Back
Top