I didn't take offense. People around here will tell you that I am hard to
offend. I just pointed out that it did work. I always use the upper case to
try and prevent errors. Just change to

select case(c)
or
select case c

and hope that users type EXACTLY as desired.

--
Don Guillett
SalesAid Software

"john_t_h " wrote in message
...
Don

Thanks for the reply.

I didn't mean to imply the code was faulty. It just did not work for
me. Sorry if I caused you offence.

I didn't not pick up on the need to have the string that is being
searched for in uppercase. Once I changed that, the code works fine.

As the data I am working from does not have any variations I typed in
as it is listed. Just for my own info, how would I change this *
Select Case UCase(C)* so it would pick up the exact text.

Thanks for your help


---
Message posted from http://www.ExcelForum.com/