title: VBA: Insert number of rows based on cell value
body: <p>Looking for a way to insert X rows above cell B9 in my workbook. The value of X will change and can be found in cell B4. This seems very simple, but I can't get this portion of my code to work. </p>
  
  <pre><code>ActiveSheet.Range("B9").Select
  Selection.EntireRow.Insert.Cells("B4"), CopyOrigin:=xlFormatFromRightOrBelow
  </code></pre>
  
  <p></p>