+ Reply to Thread
Results 1 to 2 of 2

ActiveSheet.PageSetup: Fonts size

  1. #1
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,163

    ActiveSheet.PageSetup: Fonts size

    The macro below was created by recording, I replaced the string of text with variables (sMyArray) in .LeftHeader..
    Why do I get a font size of "409" in .LeftHeader, when .CenterHeader works fine with a string?
    Please Login or Register  to view this content.
    Adding to this, the .LeftHeader text is only a partial string.
    "B Y .04.11"

    Any hints tips or examples are appreciated.
    Last edited by Rick_Stanich; 03-04-2011 at 02:44 PM.
    Regards

    Rick
    Win10, Office 365

  2. #2
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,163

    Re: ActiveSheet.PageSetup: Fonts size

    I found the answer, it was in an old post of mine.

    Thanks again to Andy who unknowingly helped out.

    http://www.excelforum.com/1937269-post4.html

    My variable starts with a numeric value and the font size became a string of ridiculous size.
    Adding a space after the font size "&16 " vs "&16" fixed the problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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