Maybe there's a difference in what you type and what's in the cell???

(Leading/trailing/extra embedded spaces???)

"Hinojosa via OfficeKB.com" wrote:

Yes sir i have tried with all caps and all lowercase but still it just
doesn't do anything.

Dave Peterson wrote:
Unless you do something special, this line is case sensitive:

If r.Value = s Then

So ASDF won't match asdf or AsDf or ASDf or ASdF or...

maybe it would be as simple as:

if lcase(r.value) = lcase(s) then

This is the macro I'm using now:

[quoted text clipped - 18 lines]
--
Message posted via http://www.officekb.com


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200610/1

--

Dave Peterson