title: Another Macro works only in debug step mode question
body: <p>Good day everyone!</p>
  <p>I've been slowly teaching myself on utilizing vba and after some brief success, have ran into a slight issue.</p>
  <p>I have two command buttons, one inserts a new row and populates 4 cells in row 8 while copying the number and formula formats of the row below it (one cell each for date and time, and two fixed text cells).  the second button only populates one cell with time once it is selected.</p>
  <p>Both macros work as intended when debugging step by step, however when they are ran via the command buttons, I get a code execution has been interrupted failure.</p>
  <p>When debugging the <code>Range(&quot;A8:H8&quot;).SpecialCells(xlCellTypeConstants).ClearContents</code> line is usually yellow highlighted however on occasion the <code>Rows(9).EntireRow.Copy</code> is.  I'm certain that there is something extremely simple that I am overlooking considering the simplicity of the code involved.</p>
  <p>I have attempted to rewrite the lines based off of various posts both on this website and others, without success.</p>
  <p>Below is the entirety of the code I have, any assistance would be greatly appreciated!</p>
  <pre><code>Private Sub CommandButton1_Click()
  
  Worksheets(&quot;Abyssal Chart&quot;).Rows(8).Insert Shift:=xlShiftDown
  
  Rows(9).EntireRow.Copy
  
  Rows(8).EntireRow.PasteSpecial xlPasteFormulasAndNumberFormats
  
  Range(&quot;A8:H8&quot;).SpecialCells(xlCellTypeConstants).ClearContents
  
  Range(&quot;A8&quot;).Value = Date
  
  Range(&quot;B8&quot;).Value = &quot;'T6&quot;
  
  Range(&quot;C8&quot;).Value = &quot;'Electrical&quot;
  
  Range(&quot;D8&quot;).Value = Time
  
  End Sub
  
  
  Private Sub CommandButton2_Click()
  
  Range(&quot;E8&quot;).Value = Time
  
  End Sub
  </code></pre>