DougStroud
Well-known Member
- Joined
- Aug 16, 2005
- Messages
- 2,968
This is an example off MS Help. This works if the last character is alpha, but fails if it is numeric.
Can this be altered to show a number w/ a superscript number?
This example makes the last character in cell A1 a superscript character.[/size]
Can this be altered to show a number w/ a superscript number?
This example makes the last character in cell A1 a superscript character.[/size]
Code:
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