Find function not recognized in my code

cmancu

Board Regular
Joined
Jan 25, 2006
Messages
52
Office Version
  1. 365
Platform
  1. Windows
Trying to write some code to look at each populated cell in column "I" and check for a specific character. Finding it will print a message in adjacent cell to the cell of found character.
I have:

Code:
' Check for Group Notations and then print note
    LR = Sheet1.Cells(Rows.Count, 9).End(xlUp).Row
    For c = LR To 1 Step -1

    If WorksheetFunction.Find("K", Range("I" & c)) > 0 Then
        Range("J" & c) = "Hooray, I found it!"
        Else
        Range("J" & c) = ""
    End If
    Next c

Would anyone be able to tell me why I get an error on the "If" line.
Error is "Unable to get the Find property of the Worksheetfunction class"

Thank you for looking.

Chris
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
That is the ticket! Thank you, thank you.

Funny thing is, I was playing with InStr to begin with, but just wasn't grasping the syntax.

Have a good day!
 
Upvote 0

Forum statistics

Threads
1,224,524
Messages
6,179,308
Members
452,904
Latest member
CodeMasterX

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top