VBA to insert and delete multiple rows

[wilsonyeoh]

Does anyone have codes to insert and delete multiple rows. I need to run a macro where a dialog box pops up requesting number of rows to insert and delete. Can anyone assist.

 

[wilsonyeoh]

Hi Norie. Is it possible to create that sort of database? Regards.

 

[saxtoda]

i'm also looking for something along these lines...

need macro (so i can add to a button) to:

1. copy row 1
2. ask how many rows to insert at row 4
3. insert 'x' rows at row 4 (so the latest record will be at the top) - obviously moving all existing records down by 'x'
4. paste contents of row 1 into each row

i have the code to copy and paste a single row, but would like to be able to add a bunch of rows at a time.

any help appreciated.