title: Inserting text to the same row but multiple columns Excel VBA
body: <p>I am new to VBA and I know that strikethrough is a text format which I believe that it can't be used in a blank cell.</p>
  
  <p>Is there a more efficient method to insert "-" to the same row but multiple columns from "D" to "G"?</p>
  
  <p>Please have a look at my coding:</p>
  
  <pre><code>Set Insert = Sheets("Cash").Cells(CashRowName, "D")
  Insert.Value = "-"
  
  Set Insert = Sheets("Cash").Cells(CashRowName, "E")
  Insert.Value = "-"
  
  Set Insert = Sheets("Cash").Cells(CashRowName, "F")
  Insert.Value = "-"
  
  Set Insert = Sheets("Cash").Cells(CashRowName, "G")
  Insert.Value = "-"
  </code></pre>