title: Excel insert rows without conditional formatting
body: <p>I am working on a macro to insert a specifiek amount of rows, so far so good. The only thing I'm struggling on is how to clear the format of the inserted cells, because atm the inserted rows use the conditional formating of the row above. </p>
  
  <pre><code>Sub RijInsert()
  '
  ' RijInsert Macro
  '
  ' Sneltoets: Ctrl+Shift+R
  '
  Dim Rng As Integer
  Dim k As Integer
  Dim rRange As Range
  
  Set rRange = Selection
  
  Rng = InputBox("Aantal in te voegen rijen?")
  For k = 1 To Rng
      Rows(rRange.Row).Insert Shift:=xlDown, _
            CopyOrigin:=xlFormatFromLeftOrAbove
  Next
  End Sub
  </code></pre>
  
  <p>Thanks :)</p>