triplehas.blogg.se

Range object where to look the value or string Optional. The main difference between the Find() and Match() functions is that the former returns the Range object where the string is found while the latter returns the position where the string has a match. Set SearchStr = rng.Find(What:=str, LookIn:=xlFormulas, LookAt:=xlWhole, MatchCase:=False)ĭebug.Print "Found at row: " & SearchStr("Banana").Rowĭebug.Print "Found at row: " & SearchStr("Melon").Rowįind a String/Value in a Column Using Match() Function in VBA Function SearchStr(str As String) As Range The code block below will demonstrate using the Find() function to return the row of the string to search. If the search is case sensitive, then True else False. It could be xlNext or xlPrevious MatchCase Optional. The cell after which you’d like the search to start. Range object where to look the value or string. Syntax: Range.Find (What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase) Find a String/Value in a Column Using Find() Function in VBA