Characters.Count Property

  • Article
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