Need Macro for Adding Rows
Posted by Shaun Culp on October 22, 2001 7:55 PM
I have a spreadsheet in which the first 3 Rows are locked and frozen (titles and summary data), the next 3 rows are unlocked and are for data entry, and the last 3 rows are again locked and have various formulas. The 3 rows in the middle (rows 4,5,and 6)need to be able to expand to accomodate more data. I want a macro that every time adds a new row before the last of the unlocked rows. That is, a macro that copies row 6, then inserts that copied row between row 5 and 6. However, I need the macro written so that the next time it is run, it copies the last unlocked row (now row 7), and inserts above it (between 6 and 7). I just can't figure out how to make it do this! Thanks for any help you can provide!