Range Search

  • Thread starter Thread starter Ray Batig
  • Start date Start date
R

Ray Batig

I have some data in the following format:

D E F G H I J K L .... more
9 a b f f f c c d f

I had some code that would search through the range and write the first
occurrence of the data into a new cell and then increment a cell to the
right. This all worked fine until I got a new set of data in which I had an
'a' in cell L9. So my output showed both a's. I really wanted only one
output of 'a' no matter how many times it showed up in any order.

How would you code a search routine for my new case?

Merry Christmas. Thanks in advance for your help!

Ray
 
Ray,

You don't say what type of code you're using for your search, but the Find
method in vb has an option to match the case or not. Alternatively, you
could assign a variable to the LCase value of the cells contents before
checking it. Or, convert the entire range to lower case before searching.

HTH,
Shockley
 
Back
Top