PC Review


Reply
Thread Tools Rate Thread

Adding a second line in a header or footer through VBA

 
 
Montana
Guest
Posts: n/a
 
      8th Feb 2008
How do I add a second line in a footer using RightFooter?
--
Peace
 
Reply With Quote
 
 
 
 
Niek Otten
Guest
Posts: n/a
 
      8th Feb 2008
Press ENTER after the first part

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Montana" <(E-Mail Removed)> wrote in message news:1BE7E17E-65E7-49E3-B336-(E-Mail Removed)...
| How do I add a second line in a footer using RightFooter?
| --
| Peace


 
Reply With Quote
 
JLGWhiz
Guest
Posts: n/a
 
      8th Feb 2008
You can use: & vbCrLf

"Montana" wrote:

> How do I add a second line in a footer using RightFooter?
> --
> Peace

 
Reply With Quote
 
Niek Otten
Guest
Posts: n/a
 
      8th Feb 2008
Sorry, forgot you want a VBA solution (which you have now)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| Press ENTER after the first part
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Montana" <(E-Mail Removed)> wrote in message news:1BE7E17E-65E7-49E3-B336-(E-Mail Removed)...
|| How do I add a second line in a footer using RightFooter?
|| --
|| Peace
|
|


 
Reply With Quote
 
Montana
Guest
Posts: n/a
 
      8th Feb 2008
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 With Quote
 
JLGWhiz
Guest
Posts: n/a
 
      10th Feb 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
header and footer boarder line Berihu Microsoft Excel New Users 1 16th Jan 2008 12:10 PM
Please help with Adding a Footer or Header =?Utf-8?B?QWw=?= Microsoft Excel Misc 2 14th Aug 2005 12:30 PM
Adding Header and Footer =?Utf-8?B?TWljaGFlbA==?= Microsoft Powerpoint 1 7th Apr 2005 02:29 PM
Adding a header and footer =?Utf-8?B?SW1wYWN0?= Microsoft Access Forms 1 8th Apr 2004 12:07 AM
Adding Header & Footer to WebForm mg Microsoft ASP .NET 3 11th Dec 2003 03:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:22 AM.