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?