title: Excel VBA: How to clear contents for specified cells when another cell contains specific text or string
body: <p>I'm having some trouble trying to find VBA code to delete multiple specific cells if a certain cell contains a specific text. This spreadsheet can run close to 100k rows as well, but will vary depending on the data pull. </p>
  
  <p>The specific VBA would be able to do the following: </p>
  
  <p>If Cell J3 equals #N/A, Blank, or 0, then clear contents of cells J3:K3 and P3:X3, and then repeat til it reaches the bottom of column J. </p>
  
  <p>Thanks in advance </p>