Font Object [Excel 2007 Developer Reference]

Switch View :
ScriptFree
Font Object
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