find text in string for multiple rows

[Merrysa]

Hi Team,
I have a attached problem where i have to find the test in a string and based on it i have to execute if statement. i have done in excel but can not execute in vba.

please do let me what is wrong with the code. attached is the file for your reference.


Sub test()


Dim I As Integer

a = Sheets(1).Range("A" & Rows.Count).End(xlUp).Row

For p = 1 To a Step 1

application.WorksheetFunction.if.ISNUMBER(SEARCH("C",cells(p,3).value)= "TRUE" Then

MsgBox "correct"

End If
Next

End Sub

[LeoTaxi]

Try

Please Login or Register  to view this content.

Kind regards
Leo

[Merrysa]

Thanks alot leo...
can we do same with Isnumber and search formula ?

[LeoTaxi]

maybe
maybe not

Cheers
Leo

[jolivanes]

@Merrysa
Refresh your memory and read the Forum Rules again. #3 Should be of interest to you.