Writing Subscript Values In VBA

Question

I have a string: `Range("T4").Value = "Rule 13s voilation"` I want to write `13s` like 13s i.e `3` and `s` are a subscript of `1`. Please suggest on how should I go about it in vba

Accepted Answer

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.

Writing Subscript Values In VBA

Solution

Problem