Macro to insert a row and copy down formulas from row above

S

Sal

Hi,

I have a workbook that has 52 protected sheets. In the data entry area
(which is not protected), I would like to create a macro so that at the touch
of a button, a new row is inserted and it will copy all the formulas down
from the row above. There are 6 rows containing formulas D, Q (these two
are hidden columns), R, S, T & U.

The first time this is run the row will be inserted after row 125 and the
next time after row 126 and so on.

I had a go at recording a macro which took the protection off the sheet,
unhid the columns D & Q inserted a row, copied down the formulas, rehid the
columns and reprotected the sheet.

Something went horribly wrong as it hid all of my columns up to Z.

Can anyone offer me some help.

Many thanks....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I insert row keeping formulas from previous row? 1
How do I insert a row or rows between each row of text and copy the row above? 0
Insert row and copy formulas 5
Insert rows and copy forumla above it 3
Macro to extend formulas 4
Insert Row also adds formulas and moves cursor 2
Copy Existing Formula Into New Row 0
Insert Row - Copy Formula From The Row Above 3

Top