| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a second line in a header or footer through VBA
How do I add a second line in a footer using RightFooter?
-- Peace |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding a second line in a header or footer through VBA
Press ENTER after the first part
-- Kind regards, Niek Otten Microsoft MVP - Excel "Montana" wrote in message ... | How do I add a second line in a footer using RightFooter? | -- | Peace |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding a second line in a header or footer through VBA
Sorry, forgot you want a VBA solution (which you have now)
-- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... | Press ENTER after the first part | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Montana" wrote in message ... || How do I add a second line in a footer using RightFooter? || -- || Peace | | |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding a second line in a header or footer through VBA
You can use: & vbCrLf
"Montana" wrote: How do I add a second line in a footer using RightFooter? -- Peace |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding a second line in a header or footer through VBA
JLGWhiz: Where does this code co in the line to be typed? e.g.,
..CenterFooter = "xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxx" -- Peace "JLGWhiz" wrote: You can use: & vbCrLf "Montana" wrote: How do I add a second line in a footer using RightFooter? -- Peace |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding a second line in a header or footer through VBA
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. "Montana" wrote: JLGWhiz: Where does this code co in the line to be typed? e.g., .CenterFooter = "xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxx" -- Peace "JLGWhiz" wrote: You can use: & vbCrLf "Montana" wrote: How do I add a second line in a footer using RightFooter? -- Peace |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| header and footer boarder line | New Users to Excel | |||
| Programming header/footer strings with line feed | Excel Programming | |||
| Please help with Adding a Footer or Header | Excel Discussion (Misc queries) | |||
| Adding a line in footer | Excel Programming | |||
| Changing (Part of) Header Without Changing Footer or Rest of Header | Excel Programming | |||
Hybrid Mode
