Font object (Excel)

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 of the Range object 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.

Worksheets("Sheet1").Range("A1:C5").Font.Bold = True

Properties

• Application
• Background
• Bold
• Color
• ColorIndex
• Creator
• FontStyle
• Italic
• Name
• Parent
• Size
• Strikethrough
• Subscript
• Superscript
• ThemeColor
• ThemeFont
• TintAndShade
• Underline

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.