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....
Bookmarks