Archive of Mr Excel Message Board
Back to Edit in Excel archive index
Back to archive home
Subtotals- How can you bold the entire line
Posted by Nikki on January 22, 2001 8:55 AM
Hi,
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 line
Posted 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 line
Posted by Dave Hawley on January 22, 2001 10:56 PM
Hi Nikki
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:
Range("A1").Entirerow.Font.Bold=True
...or
Rows(1).Font.Bold=True
Hope this helps
Dave
OzGrid Business Applications
Re: Subtotals- How can you bold the entire line
Posted 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.
Celia
Correction
Posted 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 line
Posted 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.
THANKS!!!!!
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.