title: Stop Insert row from printing cell address in new row
body: <p>I have a peculiar problem with my code. When it inserts a row below the active cell in a table, for some reason it prints the address of the new cell in the new row. For instance, if a row is inserted below the cell U9, the text &quot;U10&quot; appears in S10.</p>
  <p>I don't remember when it started doing this, but for sure it wasn't there when I first started to work on this macro - in the beginning it inserted completely blank rows. I have no idea what could have caused this change, because the line inserting the row has stayed the same.</p>
  <p>Here's what I have:</p>
  <pre><code>Sub TestSub()
  
  Dim LCU As ListColumn
  Set LCU = Worksheets(&quot;On-going&quot;).ListObjects(&quot;Table4&quot;).ListColumns(&quot;Redos (no.)&quot;)
      
  Dim rng As Range
  Set rng = Range(LCU.DataBodyRange, LCU.DataBodyRange.End(xlUp).Offset(1, 0))
  
  If rng.Columns.Count &gt; 1 Then Exit Sub
      
      For Each cell In rng
          
          If Not Intersect(rng, LCU.DataBodyRange) Is Nothing And Len(cell.Value) &lt;&gt; 0 Then
              
              ActiveCell.EntireRow.Select
              Selection.Rows.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
  
              If rng.Cells(2).Row = Selection.Row Then rng.Cells(1).Value = &quot;WTF&quot; 'Call ConditionalFormattingChange
      
          End If
  
      Next
  
  End Sub
  </code></pre>
  <p>My ultimate goal is that whenever the cell value in a certain ListColumn (&quot;Redos (no.)&quot; column) with conditional formatting changes, a row is automatically inserted below it. I have an event handler ready for it, but I use this TestSub to confirm that the code works.</p>
  <p>If the first cell of the ListColumn is changed, then I need to change conditional formatting rules, for which I have a separate macro (ConditionalFormattingChange). For simple testing purposes I have changed that to write WTF in the first cell.</p>
  <p>Everything with this code works just as I expect it to, except for the strange addition of the cell address in the new row.</p>
  <p>I have tried to insert <code>Application.CutCopyMode=False</code> before the insert row line, in case I had anything extra in my clipboard, but the address still keeps appearing. Worst case scenario, I'll probably write a line that clears the address from the cell, but I'd rather figure out what's causing this and fix the root cause.</p>
  <p>Eternal gratitude for anyone who can help!</p>
  <p>Cheers, Emma</p>