How to use find in VBA Compiler

wkullek

New member
Hello!
I would like to know how to use the find method in VBA Compiler.
I have tried many different ways, but I always get an error.

Sub abc(Param1)
Dim x
x = Application.ActiveSheet.Range(“A:A”).Find(“house”,false,false,false,false,false,false,false,false).Row
End Sub

Thank you for any advice.
 
Back
Top