ttbbbgg,

If you select 50 rows at once, and "Insert", excel will place 50 rows above
your selection...

Beege

"ttbbgg" wrote in message
...
Hi there.
I am dealing with a huge spreadsheet that will eventually be imported to a
database, however in the meantime i must only work with the spreadsheet.
I have to insert new records throughout the spreadsheet and must insert a
large number of new rows (sometimes 50 or more). Is there a macro or
something I can use that will ask me how many rows I want to insert
without
me having to do it manually?