Adding a second line in a header or footer through VBA

  • Thread starter Thread starter Montana
  • Start date Start date
Press ENTER after the first part

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do I add a second line in a footer using RightFooter?
| --
| Peace
 
Sorry, forgot you want a VBA solution (which you have now)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Press ENTER after the first part
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|| How do I add a second line in a footer using RightFooter?
|| --
|| Peace
|
|
 
JLGWhiz: Where does this code co in the line to be typed? e.g.,
..CenterFooter = "xxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxx"
 
It goes where you want the line feed to occur:

Sheets(1).PageSetup.CenterFooter = "&"Arial" &B &12 &"mytext" _
& vbCrLf & "more mytext" & vbCrLf & "more mytext"

Would give you three lines of text in Bold Arial type.
 
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

PowerPoint Separate lines (line break) - PowerPoint Footer 1
Further Challenges with Footers and automatic text wrapping 1
Footer Program 3
Word want multiple lines in Word Footer - with different formats 1
Add Footer to All Sheets 4
How write into text file at first and last line with excel vba? 3
Update Headers & Footnotes from User Form 9
Change Header/Footer w/ Worksheet Option Buttons 1

Back
Top