Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    551
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am trying to make the percentages in 14 point and the letters next to them in 12 point in the 2 charts attached. Actually, it's not just the 2 charts, i'd like to have a macro that could go through several charts and make the percents 14 pt and the letters 12 pt. So in sheet 11a of the attached, the 66% should be 14pt and the "C" next to it should be in 12 pt.

    How do i do this in a macro that will work in excel 2003 and 2007 that identifies the percents from letters. Thank you for the help.
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,913
    Thanks
    0
    Thanked 192 Times in 176 Posts
    Hi jha,

    There's a lot of code in that workbook (~350 lines) and the rather long subs have meaningless names (HowLongCanThisGoOn, WillThisNeverEnd) and few comments as to what the code is meant to be doing. Perhaps you could post a stand-alone sub comprising just that portion of the code you're having trouble with.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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