I am working on some code with Excel 2000 VBA and Microsoft
Windows 2000.

I want to do a textbox prompt, get a number and insert the
amount of rows that the user selects.

Here's what I have, but it only inserts one line, no matter
how many rows the user tells it:

' code starts here
Dim answer, counter as integer
inputbox "How many rows would you like to insert?", answer

For counter = 0 to answer
activecell.entirerow.insert
next counter
' code ends here