How to get cells.find in other sheet?

[minmark]

Dear Gents,
I'm in sheet2, and I want use cells.find method to get the column number of sheet1 that contain
specific words like "LogNo"

Dim d, e As Long

d = Cells.Find(what:="LogNo", After:=Sheet1).Row

But it shows errors.

Could you please help me to figure this out?
Thanks.

 

[sericom]

Try

d = Sheets("Sheet1").Cells.Find(what:="LogNo", LookIn:=xlValues).Row

 

[minmark]

Hi Sercom,
I use your code and show the error"Object variable or With block variable not set."
Maybe i dim d as long, I don't know what cause it.

But it still help me a lot.
I change these code to

Sub testcode1()
d = Sheet1.Cells.Find(what:="LogNo").Row
MsgBox d

And it works!
Thanks!