title: How can i add a predefined row in excel after each non empty cell in vb
body: <p>I have a flat file export of a 1 to many field in excel.
  I'm looking to update sections of the data by adding a row with predetermined values</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>A</th>
  <th>B</th>
  <th>C</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>John</td>
  <td>Male</td>
  <td>tall</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td>dark</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td>handsome</td>
  </tr>
  <tr>
  <td>Mary</td>
  <td>Female</td>
  <td>slender</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td>funny</td>
  </tr>
  <tr>
  <td>Karen</td>
  <td>Female</td>
  <td>annoying</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The value i want to append in column C:
  (i'm happy to manually add this to the code)
  Single</p>
  <p>I'm trying to create a script in vb that parses column A,
  Look for (all rows that are blank in column A &amp;&amp; where the next column A is filled)
  append a row with my value in column C</p>
  <p>The end result would look like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>A</th>
  <th>B</th>
  <th>C</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>John</td>
  <td>Male</td>
  <td>tall</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td>dark</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td>handsome</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td>single</td>
  </tr>
  <tr>
  <td>Mary</td>
  <td>Female</td>
  <td>slender</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td>funny</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td>single</td>
  </tr>
  <tr>
  <td>Karen</td>
  <td>Female</td>
  <td>annoying</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td>single</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>(i'm ok to do the last one by hand if it comes to it :))</p>
  <p>So far all i've managed to massacre is scripts that add blank lines or asterisks every blank line but to no avail</p>