VBA in Excel for Mac 2016 now thinks that ChrW(&H1D47) is not a superscript

[kylefoley76]

I upgrade from Excel for Mac 2011 to 2016 and am now getting the following error. This code takes |b and changes it into superscript b.




Dim gg As Range
Set gg = Range("a1:s16000")
gg.Replace What:="|d", Replacement:=ChrW(&H1D48), LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

When I try to go in reverse bad things start to happen. This code will work:

gg.Replace What:=ChrW(&H1D48), Replacement:="|d", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False


But it will also take 'dude' and change it to |du|de.

This also happens for all of the other superscripts not just d.