Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code- Row Insertion
I have broken up a spreadsheet into several sections. In
each section, I would like to enter code that would allow the user, once to the last row of each section, to automatically insert another row(s). I have attempted to write the code (see below) for this, but there is one problem. Once one row is entered, the new row that is created does not allow for another row to be created, i.e. if the code is referenced to row 3 and a new row is inserted (row 4), once the user hits enter in row 4, a new row cannot be created. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 3 Then Rows(Target.Row + 1).EntireRow.Insert End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row Insertion | Excel Discussion (Misc queries) | |||
Data insertion | Excel Worksheet Functions | |||
Automatic row insertion | Excel Discussion (Misc queries) | |||
Rows Insertion | Excel Worksheet Functions | |||
Rows Insertion | Excel Worksheet Functions |