Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows triggers the macro :(
My macro is working well. It inserts a row and copies formula when the
target column is selected. A beautiful thing. The problem occurs when I (or users) try to delete an row. It inserts another row, then another when they try to delete that one! It gets ugly very fast. This is the selection code: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Not Application.Intersect(Target, Range("N:N")) Is Nothing Then Target.Offset(1).EntireRow.Insert Can anyone suggest what I can change to avoid the problem? The target coulum is populated from a named list. Many thanks David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for deleting rows and serialising the remaing rows | Excel Programming | |||
Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
Macro for deleting rows and serialising the remaing rows | Setting up and Configuration of Excel | |||
Macro for deleting rows and serialising the remaing rows | Excel Worksheet Functions | |||
Macro that triggers off a combo box | Excel Discussion (Misc queries) |