Excel does not recognize text in a worksheet

[Julie D]

I'm trying to use a Macro to change numbers 2 and 3 to superscript. (as in,
g/m2, in3, etc) The macro tells me it can't find the character sequence I've
identified to allow it to recognize what needs to be superscripted.
(everything between tildes) Now when I go back and try to find the tilde
set, or anything using the Find command, nothing happens. (I mean, I click
"Find Next" or "Find All" and nothing happens--this is true no matter what I
search for) I CAN get the worksheet to recognize the information using
search or find formulas--but this doesn't really help me in running my
macro...
anyone have any ideas?

 

[Gord Dibben]

Without seeing your code and sequence and how you are using the tildes, hard to
say.

A tilde is a wildcard character.

To find a tilde use two tildes...............~~

To format superscripts of squared or cubed see this macro.

Sub sq_Meters()
Selection.NumberFormat = "0"" m" & Chr(178) & """"
'0179 for cubic meters
End Sub

You should be able to adapt to suit.


Gord Dibben MS Excel MVP