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!

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:

Range("A1").Entirerow.Font.Bold=True

...or

Rows(1).Font.Bold=True

Hope this helps

Dave

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.

Celia

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

Correction

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.

THANKS!!!!!