Returns a Characters object that represents a range of characters within the object text. Use the Characters object to format characters within a text string.
Syntax
expression.Characters (Start, Length)
expression A variable that represents a Range object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Start | Optional | Variant | The first character to be returned. If this argument is either 1 or omitted, this property 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, this property returns the remainder of the string (everything after the Start character). |
Remarks
The Characters object isn't a collection.
Example
This example formats the third character in cell A1 on Sheet1 as bold.
With Worksheets("Sheet1").Range("A1")
.Value = "abcdefg"
.Characters(3, 1).Font.Bold = True
End With