title: Clear cell contents with a WKS IF function
body: <p>First, I must admit, I am not a VBA programmer.   I am building a spreadsheet and using the Record Macros to generate VBA to do some of the automated tasks.<br>
  I'd like to use the Fill Up and Fill Down function in Excel 2016, (I know this function is available with Get/Transform, but I am wanting to do this with VBA Macros).</p>
  
  <p>My problem is that the Fill up / Fill down doesn't work because it is looking for a blank cell, so the cursor jumps to the bottom of the column in the table without filling in any values. Note, I have filled in the value 0, so I can test for this value to then clear the cell contents. </p>
  
  <p>I'd like to use an If function statement, something like this, to clear out the cells, so the fill up/down will work:   if (a1=0, clear, a1)</p>
  
  <p>I know that syntax is not correct, but can you suggest something like this that I can do with functions?</p>
  
  <p><a href="https://i.stack.imgur.com/x9fdC.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/x9fdC.jpg" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/4lq25.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4lq25.jpg" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/DKLzU.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DKLzU.jpg" alt="enter image description here"></a><a href="https://i.stack.imgur.com/W3PSg.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/W3PSg.jpg" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/QcRjb.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QcRjb.jpg" alt="enter image description here"></a><a href="https://i.stack.imgur.com/cVrO7.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cVrO7.jpg" alt="enter image description here"></a></p>