Excel Macro: Bold Entire Row if Cell Contains the word Total

Hi excelforum Experts,

I am trying to format the entire row into Bold if the cell contains the word "Total". Is it correct putting an asterisk sign as prefix and suffix to the word "Total" as wild character to capture each cell that contains the word "Total"?

Here are the possible words that will contain the word Total:
1.) Total Assets
2.) Total Liabilities
3.) Total Equities
4.) Grand Total
5.) Sub-total
6.) And so on...

Please see VBA code below that I am referring to:

VBA Code Sample.png

I appreciate if there could be someone that could help me fix the VBA code above and arrived at my desired output as mentioned above. Thanks!

Warmest regard,
Arnel

Hi Norie,

Thanks for your immediate feedback and for the clarifications! I appreciate it much.

Warmest regards,
Arnel

Try:

Please Login or Register  to view this content.

HTH,
Maud