Font Object

Excel Developer Reference

Contains the font attributes (font name, font size, color, and so on) for an object.

Remarks

If you don’t want to format all the text in a cell or graphic the same way, use the Characters property to return a subset of the text.

Example

Use the Font property to return the Font object. The following example formats cells A1:C5 as bold.

Visual Basic for Applications
  Worksheets("Sheet1").Range("A1:C5").Font.Bold = True

See Also