title: Getting error "Object variable or With Block variable not set" while finding column number
body: <p>I want to find column number of cell where text "Remarks" is present in row 1. In my case row 1 and row 2 are merged.
  I am using below logic to find the column number, but I am getting <code>Runtime error 91; Object variable or With Block variable not set</code></p>
  
  <pre><code>Dim lnRow As Long, lnCol As Long
  
  lnRow = 1
  lnCol = Sheet1.Cells(lnRow, 1).EntireRow.Find(What:="Remarks", LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False).Column
  </code></pre>
  
  <p>What am I doing wrong here?</p>