+ Reply to Thread
Results 1 to 3 of 3

Formatting Headers and Footers in Excel 2003

  1. #1
    Registered User
    Join Date
    04-06-2010
    Location
    Edinburgh
    MS-Off Ver
    Excel 2003
    Posts
    6

    Formatting Headers and Footers in Excel 2003

    I am trying to format headers and footers in an Excel 2003 Spreadsheet using VBA.

    More specifically I would like to justify the the text in the Centre and Right hand Headers/Footers to align to the left. When I use the &L operator it moves the text into the Left hand header/footer. I've tried padding with spaces to manually align text, but this has no effect no matter how many spaces I input to the text.

    I've also tried putting all the text into the Left hand header/footer in the hope that it will stretch across the page, but this only gives me an error (the total text is less than 255 characters).

    One final point - I would like to put an ampersand (&) in as text but Excel always reads this as an operator prefix even when I try adding it as Chr(38) rather than the actual & sign. Can this be got around?

    Thanks for any help or advice.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Formatting Headers and Footers in Excel 2003

    The first part you cannot do, either in the UI or in VBA. For the second part, you need to double up the & character.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    04-06-2010
    Location
    Edinburgh
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Formatting Headers and Footers in Excel 2003

    Ok. Thanks for the information.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1