ExcelBanter - Changing font size, bold and underline

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Changing font size, bold and underline (https://www.excelbanter.com/excel-programming/285647-changing-font-size-bold-underline.html)

ChuckM[_2_]

Changing font size, bold and underline

Hello,
How would I change the font size, bold, and underline for the contents of a cell?
Thanks
ChuckM

Chip Pearson

Changing font size, bold and underline

Chuck,

Try something like the following:

With Range("A1").Font
.Bold = True
.Underline = True
.Italic = True
.Size = 16
End With

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"ChuckM" wrote in message
m...
Hello,
How would I change the font size, bold, and underline for the
contents of a cell?
Thanks
ChuckM

All times are GMT +1. The time now is 09:16 PM.