Inserting a number of rows into excel

Howdy,

I am new to VB, and need to get something done quick.

I need to create a form that will allow for a user to input a value (1 - 300).

Then I need for that value to be equal to the number of rows present in the excel sheet.

Can someone aid me in trying to figure this out?

Thanks

Quote:

---

Then I need for that value to be equal to the number of rows present in the excel sheet.

---

please explain, do you want to insert rows or fill rows or what? you can not change the total number of rows in a worksheet