title: Vba code: Filling the blank cells with zero dynamically
body: <p>I need to fill my blank cells in a worksheet with zero. Currently I was doing it for C12:H35. Can someone please tell what's wrong in my code.Its not even giving any error.Also I need to do it dynamically .  So I was trying to do as</p>
  
  <p><code>Dim sht as Worksheet
    Set sht = This Workbook.Sheets("MySheet")
  sht.Range(sht.cells(C12:3),sht.cells(12,Columns.count).End(xlToLeft)).Select</code></p>
  
  <p>None is working :(</p>
  
  <p>This code is for non dynamic range,which again isn't working</p>
  
  <pre><code>  Sub FillEmptyCell
        Dim rng as Range
        Dim i as Long
        Dim cell as Range
    Set rng= Sheets("Mysheet").Range("C12:H35")
  
  For each cell in rng
    If cell.value = " " Then cell.value= "0"
    End if 
  Next
  End Sub
  </code></pre>