Writing Subscript Values In VBA

Question

I have a string:
Range("T4").Value = "Rule 13s voilation"

I want to write 13s like 1_3s
i.e 3 and s are a subscript of 1.

Please suggest on how should I go about it in vba

Answer 1

Try the following:

Range("T4").Value = "Rule 13s voilation"
Range("T4").Characters(Start:=7, Length:=2).Font.Subscript = True

I am not sure how this will work for you with dynamic string lengths.

Answer 2

Try doing it manually while recording a macro, and then looking at the resulting code. That will give you your answer.

Here's a cleaned up answer:

With Range("T4")
    .Value = "Rule 13s voilation" ' (sic)
    .Characters(Start:=7, Length:=2).Font.Subscript = True
End With