| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I insert a row below the active row?
I want to enter data via a macro which is currently working but inserting a
new row moves the new entry dow so lists are built from the bottom up rather than top down. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I insert a row below the active row?
Here is one way:
Row = Selection.Row() Cells(Row + 1, 1).Select Selection.EntireRow.insert "M. Higginbottom" <M. wrote in message ... I want to enter data via a macro which is currently working but inserting a new row moves the new entry dow so lists are built from the bottom up rather than top down. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a new Worksheet AFTER the existing (Active) sheet | Excel Worksheet Functions | |||
| how do i insert page number on active cell? | Excel Discussion (Misc queries) | |||
| Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
| Insert a number of rows based on a value in a cell on active row | Excel Worksheet Functions | |||
| Adding a control button to insert a date in the active cell. | Excel Discussion (Misc queries) | |||
Linear Mode
