friends
I'm using this code to search in a specific column in sheet
My problem is:
- Search is Case Sensitive
- I want to search with any part of the word, not from the start
I'm using this code to search in a specific column in sheet
My problem is:
- Search is Case Sensitive
- I want to search with any part of the word, not from the start
Code:
Dim LastRow As Integer
LastRow = Worksheets("Database").Cells(Rows.Count, 2).End(xlUp).Row
Dim i As Integer
i = 0
For Each C In Worksheets("Data").Range("B2:B" & LastRow)
If C Like txtSearch.Value & "*" Then
End If
Next C