ExcelBanter - Find sub-str in a cell.value

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Find sub-str in a cell.value (https://www.excelbanter.com/excel-programming/410378-find-sub-str-cell-value.html)

miek

Find sub-str in a cell.value

lStr = Worksheets(1).Cells(i, 5).Value

How do I find the word "test" within the lStr variable

Thanks

Gary''s Student

Find sub-str in a cell.value

Use the InStr() function
--
Gary''s Student - gsnu200783

"miek" wrote:

lStr = Worksheets(1).Cells(i, 5).Value

How do I find the word "test" within the lStr variable

Thanks

All times are GMT +1. The time now is 09:30 AM.