How to add empty rows to the JQGrid?

How to write a macro in Excel to add "x" amount of rows.?

• I want to write a macro that will look at the last row used on a worksheet and add "x" amount of rows below the last used row where "x" is the result of a cell in another worksheet within the same spreadsheet. Example: Last row used on Sheet 1! is 206 and in row 208 I have a totals line. I want to add rows in between row 206 and 208 where the number of rows to add is derived from a subtotal formula in Sheet 2! cell a110. What would the code for this macro look like? Any help would be appreciated. Thanks.

• Answer:

  try this... Sub InsertRows() Dim NumberofRows, LastRow As Integer NumberofRows = Worksheets("Sheet2").Range("A110").Value LastRow = Worksheets("Sheet1").Range("A1"). _ End(xlDown).Row Rows(LastRow + 1 & ":" & LastRow + NumberofRows).Insert shift:=xlDown End Sub