Archive of Mr Excel Message Board
Back to Edit in Excel archive index
Back to archive home
Subtotals- How can you bold the entire linePosted by Nikki on January 22, 2001 8:55 AM
Was creating a Macro which includes subtotals. Everything is fine, but Excel only automatically bolds the Name column but not the number column (in the subtotal row).
I tried to go into VB and add a command. However, my VB knowledge is limited and I was unable to accomplish what I needed to.
Any suggestions? Thanks for your help!
Re: Subtotals- How can you bold the entire linePosted by Mark W. on January 22, 2001 11:45 AM
Why don't you setup a conditional format that bolds
the entire line if it finds the substring "Total" in
a given column?
Re: Subtotals- How can you bold the entire linePosted by Dave Hawley on January 22, 2001 10:56 PM
I'm not sure what you mean by your use of Subtotals (Data>Subtotals?) but to bold an entire row via VBA you could use:
Hope this helps
OzGrid Business Applications
Re: Subtotals- How can you bold the entire linePosted by Celia on January 23, 2001 2:36 AM
Click on "row levels" #2 so that only the sub-total rows are visible.
Select the entire range of your data.
Go to Edit-GoTo-Special-VisibleCellsOnly and click OK.
Format the selected cells as Bold.
CorrectionPosted by Celia on January 23, 2001 2:38 AM
Forget that. Just noticed that you are looking for a VBA solution.
Re: Subtotals- How can you bold the entire linePosted by Nikki on January 26, 2001 8:48 AM
Thanks for the suggestions. Instead of playing in visual basic, I think I will just take Cecelia's suggestion.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.