syntax error

[onenessboy]

HI all,

the below is giving error...i want to search String pattern RAV in the range.. RAV may be in any position in the cell value...
for example... the word ravi is in multiple rows in the column like RAVIKUMAR, RAVI PRASAD like this...but i need to search for pattern 'RAVI' in all rows...



If Range("B" & CStr(LSearchRow)).Value = "%RAVI%"

can you please correct above syntax please....

[jeffreybrown]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.