title: Select first empty cell in column F starting from row 1. (without using offset )
body: <p>This is one query that I am really confused with. Coz I have looked for this so many times but I always find the codes related to finding the last used or first non empty cell.
  Tried at below codes. diff codes have been separated by the word "even"</p>
  
  <pre><code>iRow = Worksheets("Sheet1").Cells(Rows.Count,1).End(XlUp).Row 
  </code></pre>
  
  <p>even</p>
  
  <pre><code>Sub LastCellBeforeBlankInColumn()
  
  Range("A1").End(xldown).Select
  
  End Sub
  </code></pre>
  
  <p>even</p>
  
  <p>Find the very last used cell in a Column:</p>
  
  <pre><code>Sub LastCellInColumn()
  
  Range("A65536").End(xlup).Select
  
  End Sub
  </code></pre>
  
  <p>even</p>
  
  <p>Find the last cell, before a blank in a Row:</p>
  
  <pre><code>Sub LastCellBeforeBlankInRow()
  
  Range("A1").End(xlToRight).Select
  
  End Sub
  </code></pre>
  
  <p>even</p>
  
  <p>Find the very last used cell in a Row:</p>
  
  <pre><code>Sub LastCellInRow()
  
  Range("IV1").End(xlToLeft).Select
  
  End Sub
  </code></pre>
  
  <p>even</p>
  
  <pre><code>Worksheets("Sheet1").Range("A1").End(xlDown).Row + 1
  </code></pre>
  
  <p>even</p>
  
  <pre><code>LastRow = Range("A" &amp; Rows.Count).End(xlUp).Row + 1
  Sheets("SheetName").Range("A" &amp; LastRow).Paste
  </code></pre>
  
  <p>even</p>
  
  <pre><code>Dim FirstBlankCell as Range
  Set FirstBlankCell=Range("A" &amp; rows.Count).end(xlup).offset(1,0)
  FirstBlankCell.Activate
  
  'Find the last used row in a Column: column A in this example
  Dim LastRow As Long
  Dim NextRow As Long
  With ActiveSheet
      LastRow = .Cells(.Rows.Count, "F").End(xlUp).Row
  End With
  NextRow = LastRow + 1
  </code></pre>