| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a button to insert a new row.
I know Excel can do it; I just don't know how. In addition, once the new row
is inserted, I need the formulas to carry into it. Any help is greatly appreciated! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a button to insert a new row.
I can think of many possibilities, but I'm sure you are thinking of something
very specific. Please give more information. -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Sharon" wrote: I know Excel can do it; I just don't know how. In addition, once the new row is inserted, I need the formulas to carry into it. Any help is greatly appreciated! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a button to insert a new row.
Assuming you want the inserted row at the cursor location:
Sub InsertIt() On Error Resume Next Rows(Activecell.Row).Insert Rows(Activecell.Row-1).Resize(2).FillDown Rows(Activecell.Row).specialcells(xlcelltypeconsta nts).clearcontents End Sub "Sharon" wrote in message ... I know Excel can do it; I just don't know how. In addition, once the new row is inserted, I need the formulas to carry into it. Any help is greatly appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Button in Excel | Excel Worksheet Functions | |||
| insert row above button (retrieve position of button) | Excel Discussion (Misc queries) | |||
| create a control button to insert rows | Excel Discussion (Misc queries) | |||
| How to create a form to insert a hyerlink.VBA code to create a for | Excel Discussion (Misc queries) | |||
| INSERT NEW ROW MACRO BUTTON | Excel Discussion (Misc queries) | |||
Hybrid Mode
