How to BOLD sub-total and TOTAL row

[rickyfong]

I got some transactions with sub-total as a row for each invoice, and Grand total as the last row. In Excel VBA, how to make those sub-total and Grand Total row with bold format cause one of customer made this request. Thanks a lot!!

 

[Brianwarnock]

Cells(row,col).font.bold=true

 

[accedeholdings]

Cells(row,col).font.bold=true

This is also the solution that I thought of.