How to use find in VBA Compiler

XLS Padlock
1

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.

2

Which error are you getting for the code you pasted?

3

Hello,
your answer to my other question solved the problem. I have different files.
Thank you very much!