| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro help. Insert row and copy formulas from row above
I have a worksheet that I need to insert rows but copy only the formulas from
the row above. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro help. Insert row and copy formulas from row above
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 "Kesbutler" wrote: I have a worksheet that I need to insert rows but copy only the formulas from the row above. Any suggestions? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro help. Insert row and copy formulas from row above
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 "Kesbutler" wrote: I have a worksheet that I need to insert rows but copy only the formulas from the row above. Any suggestions? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro help. Insert row and copy formulas from row above
Is there a way to have it copy only the formulas? Also, the workbook will be
password protected. "Joel" wrote: 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 "Kesbutler" wrote: I have a worksheet that I need to insert rows but copy only the formulas from the row above. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert row and copy formulas | Excel Discussion (Misc queries) | |||
| Insert row & copy formulas | Excel Programming | |||
| Macro to insert a row and copy down formulas from row above | Excel Discussion (Misc queries) | |||
| Macro to insert copy and insert formulas only to next blank row | Excel Programming | |||
| Insert Row and copy formulas | Excel Programming | |||
Linear Mode
