lovingexcelbutconfused
New Member
- Joined
- Jan 25, 2005
- Messages
- 5
Hi;
I need to insert rows within excel; 2000 rows to be exact and these are in multiple spreadsheets. Is there a macro/visual basic code I can use to run this? I know something with a do until (last row) would work but dont know how to tell excel to move insert after skipping two rows, and then inserting, and then skipping etc etc
thanks
I need to insert rows within excel; 2000 rows to be exact and these are in multiple spreadsheets. Is there a macro/visual basic code I can use to run this? I know something with a do until (last row) would work but dont know how to tell excel to move insert after skipping two rows, and then inserting, and then skipping etc etc
thanks