2010-02-28, 22:20 #1
- Join Date
- Jan 2001
- 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.
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2010-03-02, 22:28 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- Thanked 177 Times in 163 Posts
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,
[MS MVP - Word]