Excel Question. PLS help. inserting unknown # of rows.

[schne10134]

Hello,

I have a spreadsheet that i would like to ask the User how many accounts there are, and then have that many rows inserted into the spread sheet. So, for example there are 4 accounts, i would like the area under "accounts" to move eveything else down 4 rows and insert enough room to enter data for 4 accounts..

Any one have any ideas? thanks alot!!

eds.

 

[xlbo]

dim noRows as long
noRows = inputbox("How many accounts&quot
Rows("2:" & noRows+1).Insert Shift:=xlDown

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244