Deleting rows triggers the macro :(


D

Dav1d

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top