How do you superscript code/text in VBA?

Question

How do you superscript code/text in VBA?

Anonymous

How can I superscript the letter "i" in parenthesis of last line below to be like the 1 and 2 in the lines above (bolded for clarity)? I am not the one who wrote this macro and am trying to make updates...

Selection.Replace What:="&lt;sup&gt;1&lt;/sup&gt;", Replacement:="**¹**", LookAt:=xlPart \_ 

    , SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, \_ 

    ReplaceFormat:=False 

Selection.Replace What:="&lt;sup&gt;2&lt;/sup&gt;", Replacement:="**²**", LookAt:=xlPart \_ 

    , SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, \_ 

    ReplaceFormat:=False 

Selection.Replace What:="&lt;sup&gt;i&lt;/sup&gt;", Replacement:="**i**", LookAt:=xlPart \_ 

    , SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, \_

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Answer 1

Anonymous

Looks like that worked for the macro after running! Thank youX1000!

0 comments

Answer 2

HansV 462.6K

Try Replacement:=ChrW(&H2071)

0 comments

Share via

How do you superscript code/text in VBA?

2 answers