title: Excel VBA Index Match Only Blank Row
body: <p>I have a long list of data, eg. 5000 row, some already filled up with data, some is blank, i want to add a formula to the blank cells, i have below vba codes but having problem in the formula with fixed row number, ie. E3435, how can i replace it with vba code if i need to add formula based on different row number? Thanks    </p>
  
  <pre><code>Sub FillInBlanks()
  Dim rng As RANGE, cell As RANGE
  Set rng = ActiveSheet.RANGE("c3:A4133")
  For Each cell In rng
     If IsEmpty(cell) Then
     cell.formula = "=DATE(YEAR(E3435),MONTH(E3435),DAY(E3435))"
     End If
    Next cell
  End Sub    
  </code></pre>