Code to add rows and continue formulas

Im looking to create a userform to add new rows to a sheet, and continue the formulas in certain columns.
The user starts by entering a number in the text box tbRowAdd. When the user clicks on the button called btAdd it first checks to make sure the number entered is equal to or between 1 and 1500. If this is not the case it should display a message box saying "You must enter a valid number from 1 to 1500 in the tex box."
If the number is valid it should then add that amount of rows below the current active cell in the worksheet ReturnData.
It should then continue the formulas in the A, B, C and F columns. The formulas are as follows:

A: =IFERROR(IF($D6="", "", ROW($A6)-ROWS($A$1:$K$5)),"")

B: =IFERROR(RANK($C6,$C$6:$C$99986, 1),"")

C: =IFERROR(IF(OR(AND(ReturnData!$D6>=Search!$E$1, ReturnData!$D6<=Search!$E$2),OR(Search!$E$1="", Search!$E$2="")), IFERROR(SEARCH(Search!$E$3,$E6,1),"")-(-IFERROR(SEARCH(Search!$E$4,$F6,1),""))-(-IFERROR(SEARCH(Search!$E$5,$G6,1),""))-(-IFERROR(SEARCH(Search!$E$6,$H6,1),""))-(-IFERROR(SEARCH(Search!$E$7,$I6,1),""))+ROW()/100000, ""), "")

F: =IFERROR(VLOOKUP($G6, EquipmentData!$B$3:$C$1048576, 2, FALSE),"")

Each number in bold should match the row number (I dont know if this happens automatically or requires coding)

Thanks,
James

Hi Nitefox, have you tried copying the last row (seems like row 6 from your post) and pasting them to new rows, instead of creating them?



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Row 6 is the first row. There are a couple of thousand records (and growing). Im looking to mainly use this code for adding rows in-between.

Perhaps inserting blank rows-in-between, then copy the last row (before the first inserting blank row) and paste it to the blank rows-in-between?



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

I dont want to copy the values just the formulas.