On Wed, 2 Apr 2008 14:04:01 -0700, carl wrote:

I am using this macro graciously provided by a group member. I am trying to
modify it so that it is case sensitive to the values in ColA.

Seems to me it should be case sensitive as written, unless you've got an

Option Compare Text

statement at the beginning of your module. If so, just remove it.

If you want the comparison to be case insensitive, then add

Option Compare Text

prior to the start of your procedure.
--ron