Characters.Count property (Excel)

Returns a Long value that represents the number of objects in the collection.

Syntax

expression.Count

expression A variable that represents a Characters object.

Example

This example makes the last character in cell A1 a superscript character.

Sub MakeSuperscript() 
 Dim n As Integer 
 
 n = Worksheets("Sheet1").Range("A1").Characters.Count 
 Worksheets("Sheet1").Range("A1").Characters(n, 1) _ 
 .Font.Superscript = True 
End Sub

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.