Macro help. Insert row and copy formulas from row above

  • Thread starter Thread starter Kesbutler
  • Start date Start date
K

Kesbutler

I have a worksheet that I need to insert rows but copy only the formulas from
the row above. Any suggestions?
 
to copy the last row and maintain your formulas it is best to copy the last
row and insert the copy before the last row. Thne clear the non-formula
cells from the last row. A little backwards, but it will work.


Lastrow = range("A" & rows.Count).end(xlup).Row
Rows(Lastrow).copy
Rows(Lastrow).Insert
Rows(Lastrow + 1).SpecialCells(xlCellTypeConstants).ClearContents
 
I have following formula working. But the new row is not protected. Is there
a way to have the macro lock the cells with the formula so they cannot be
updated by users?

Thanks
 
Is there a way to have it copy only the formulas? Also, the workbook will be
password protected.
 

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

Keeping formulas on an insert 1
Insert Value into cell automatically when new rows are created/inserted 1
Changes in How Code Acts After Upgrade of Excel 2
Insert Row also adds formulas and moves cursor 2
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Mid column sum formulas with varied ranges to sum 17
Excel Help to copy information from one row at a time to another sheet 1
Insert formula and copy to a range of cells above 2

Back
Top