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.