Help with .Find (1 Viewer)

Hi I am trying to manipulate some code to "Find" two possible characters. Originally the code was only looking to find "L", however it has been determined that in some instances only an "S" may appear. Below is the original code and what I expected to the code to look like but clearly it is wrong. I colored my modification in red. I tried to scour the boards for a solution but could not find one.

Original Code
RowNo = objExcel.Range("B1:B" & lastrow2).Find(what:="L", lookat:=xlWhole).Row - 1

Modified Code but not working
RowNo = objExcel.Range("B1:B" & lastrow2).Find(what:="L" or "S", lookat:=xlWhole).Row - 1

Any help would be greatly appreciated. :banghead:

so far as I am aware, you do not have that flexibility with Excel find, you need to loop through the values you want to search for. See this link for and example

https://www.computing.net/answers/o...hes-in-excel-performed-at-one-time/20692.html