MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Subtotals- How can you bold the entire line

Posted 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!

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?

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:




Hope this helps


OzGrid Business Applications

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.


Posted by Celia on January 23, 2001 2:38 AM


Forget that. Just noticed that you are looking for a VBA solution.

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.