Upper Case and Lower Case

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

The below function and snipplet will find the string "AD" fine. My problem
is that I have a cell before the cell containing "AD" that contains the word
"Grade". Is there a way to use either LCASE or UCASE to differentiate
between lower case and upper case strings? If so, should I modify the
FINDCELL function to use UCase or LCase?


Set cell = FindCell("*" & sSearchString & "*", Sheets(1).Cells)



Function FindCell(searchFor As String, _
searchRange As Range) As Range

Application.DisplayAlerts = False
With searchRange

Set FindCell = .Find(what:=searchFor, After:=.Cells(.Cells.Count), _
LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False)

End With
End Function
 
Can you give me some syntax or point me to where i can find an explanation
of matchcase?
 
Hi Scott,

Look at "Find Method" in VBA help.

The MatchCase argument can only take the values True or False.
 
Look at your own syntax. I have cut out the part where you have set
MatchCase to False:

SearchDirection:=xlNext, MatchCase:=False)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

wher to put the code 4
move cell 5
Copying a Cell 4
Test if Cell is Empty or Doesn't Exist 2
Overflow error 3
Convert list to UPPER, lower & Proper cases. 21
auto convert to upper case 1
Resize to last entry in row and copy to sheet 1 3

Back
Top