Best loop to use?

Well this worked great--
Thanks for all your help today!

YLP

MD-
You are right, there is a situation that has come up w/ the letters mm.
I have a lot of records that are wheels and will have mm at the end to indicate millimeters.
I have one product name that is MMVI, roman numeral. So it gets converted to mmvi.
I don't want to search for something like this each time, is there something that will say only if nothing proceeds mm or follows mm, for this case specific?
[VBA]If InStr(c, "Mm") > 0 Then c.Formula = _
Application.WorksheetFunction.Substitute(c.Formula, "Mm", "mm")[/VBA]

You can incorpotate a space into the string
" mm" or "mm "
There is still a problem if it occurs at the start/end of the cell, since there will be no space. Hence my earlier code which didn't work.

Right,
Well when you and I have some time, maybe we can dig in to that code together and see why it was breaking. I think part of it is the demand on the memory. After running that code, it flooded my memory and other reliable programs w/ much less demands were failing. I had to reboot to flush the memory to run other Excel macros.

TA,

YLP