DisplayFormat.Characters property (Excel)

Returns a Characters object that represents a range of characters within the text of the associated Range object as it is displayed in the current user interface. Read-only.

Syntax

expression.Characters (Start, Length)

expression A variable that represents a DisplayFormat 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).

Return value

Characters

Remarks

The Characters object is not a collection.

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.