Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Upper Case and Lower Case
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Upper Case and Lower Case
Why not set matchcase to True?
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Upper Case and Lower Case
Can you give me some syntax or point me to where i can find an explanation
of matchcase? "Claud Balls" wrote in message ... Why not set matchcase to True? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Upper Case and Lower Case
Hi Scott,
Look at "Find Method" in VBA help. The MatchCase argument can only take the values True or False. --- Regards, Norman "scott" wrote in message ... Can you give me some syntax or point me to where i can find an explanation of matchcase? "Claud Balls" wrote in message ... Why not set matchcase to True? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Upper Case and Lower Case
Look at your own syntax. I have cut out the part where you have set
MatchCase to False: SearchDirection:=xlNext, MatchCase:=False) *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Upper Case and Lower Case
that's for pointing out the obvious.
"Claud Balls" wrote in message ... Look at your own syntax. I have cut out the part where you have set MatchCase to False: SearchDirection:=xlNext, MatchCase:=False) *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
How do I change a column in Excel from upper case to lower case? | Excel Worksheet Functions | |||
How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) |