title: Excel VBA - Replace Null Cells in Columns C-F with Zero if Column A Contains a Value
body: <p>I have a data-set that contains 7 columns. I am trying to write a macro that looks to see if column A is not null, if it isn't null then I want to replace null cells in the corresponding C-F columns with 0. The number of records in column A will change from time to time so the macro will need to account for that.</p>
  <p>I want this:</p>
  <p><a href="https://i.stack.imgur.com/AqJUK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AqJUK.png" alt="Before_Macro" /></a></p>
  <p>to turn into this:</p>
  <p><a href="https://i.stack.imgur.com/GremW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GremW.png" alt="After_Macro" /></a></p>
  <p>This seems really simple I am just very new to VBA so any assistance will be greatly appreciated!</p>