title: Search for string to move one row lower
body: <p>Sheet contains commission data for employees.<br />
  Data is dumped out of Accounting system each week.<br />
  Need to move a cell value &quot;Totals&quot; down 1 row to align with the relevant data.</p>
  <p>Have tried to search for the string &quot;Totals&quot; then cut and paste 1 row lower.</p>
  <p>The string is in col-A.  The dataset size and content rows is variable each week but the target string is always in col-A and needs to drop down 1 row, probably with an offset (1, 0) style of command?</p>
  <pre class="lang-vb prettyprint-override"><code>Dim m As Integer
  m = 2
      
  Do Until m = 300 'this is set to cover the expected occurrences
      
      On Error Resume Next
      Range(A1, A300).Cells(&quot;m&quot;, 0).Find(What:=&quot;Totals&quot;).Offset(1, 0) = &quot;TOTALS&quot;
      m = m + 1
      On Error GoTo 0
  
  Loop
  </code></pre>
  <p>Getting no error messages but no results either!</p>