View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JacMar JacMar is offline
external usenet poster
 
Posts: 12
Default Headers and Footers in VBA

I use Excel 2002. I recently got info from this group about printing headers
and footers on selected pages, and it worked very well. Now my question is;
How do I specify a multi line header (of footer), in a format similar to an
address, ie:

Name
Street address
City, State
Zip Code

I have not been able to find code to force a Carriage Return.

Thanks in advance