Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row macro
I am so new to this macro thing, so please when you respond, make is simple :)
I would like to have a macro to insert eight rows relative to where my cursor is. The entire macro I was trying to create was to insert eight rows and autofill the contents that sit below the new eight rows that are created. My macro works, but only in the cell I created it for - not relative to where I need it. I know there must be some special code to get this to work. Thanks in advance - I love this site. -- Janette |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row macro
Sub EightMoreRows() ActiveCell.Offset(1, 0).Resize(8, 1).EntireRow.Insert shift:=xlDown End Sub '- Helpful posting advice here... http://www.cpearson.com/excel/newposte.htm -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins - free trial for "Rows to Repeat at Bottom") "Janette" wrote in message I am so new to this macro thing, so please when you respond, make is simple :) I would like to have a macro to insert eight rows relative to where my cursor is. The entire macro I was trying to create was to insert eight rows and autofill the contents that sit below the new eight rows that are created. My macro works, but only in the cell I created it for - not relative to where I need it. I know there must be some special code to get this to work. Thanks in advance - I love this site. -- Janette |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
Recorded single column insert in macro. Macro inserts two not one | Excel Programming | |||
make a macro to insert a macro | Excel Discussion (Misc queries) | |||
Macro to insert copy and insert formulas only to next blank row | Excel Programming | |||
Insert A Row Macro | New Users to Excel |