Share via


Characters.Count Property

Excel Developer Reference

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.

Visual Basic for Applications
  Sub MakeSuperscript()
    Dim n As Integer
n = Worksheets("Sheet1").Range("A1").Characters.<strong>Count</strong>
Worksheets("Sheet1").Range("A1").Characters(n, 1) _
.Font.Superscript = True

End Sub

See Also