Syntax

expression.Characters(Start, Length)

expression An expression that returns a TextFrame object.

Parameters

Name Required/Optional Data Type Description
Start Optional Variant The first character to be returned. If this argument is either set to 1 or omitted, the Characters method returns a range of characters starting with the first character.
Length Optional Variant The number of characters to be returned. If this argument is omitted, the Characters method returns the remainder of the string (everything after the character that was set as the Start argument).

Return Value
Characters

Remarks

The Characters object isn't a collection.

Example

This example formats as bold the third character in the first shape's text frame on the active worksheet.

Visual Basic for Applications
With ActiveSheet.Shapes(1).TextFrame .Characters.Text = "abcdefg" .Characters(3, 1).Font.Bold = True End With
characters Characters Method

See also: