"If not intersect" question

[quackdad]

I have a line of code to trigger a macro when a cell in specified column range is selected:

If Target <> "" And Not Intersect(Target, Range("D6:D1048576")) Is Nothing Then

Is there a simple modification I can make so the macro will not be triggered when I insert a new row?

 

[Fluff]

Do you only want it to run when you change a single cell?

 

[quackdad]

Correct, any single cell in the Range D6:D1048576; never multiple.

 

[Fluff]

Ok put this line above the one you posted.

If Target.CountLarge > 1 Then Exit Sub

 

[quackdad]

Ok put this line above the one you posted.

If Target.CountLarge > 1 Then Exit Sub

Lovely, Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.