Event procedure debug error

[RattlingCarp3048]

I have an event procedure that basically says if column D changes show me a message box. so why is it when i insert a column or row anywhere in the document i get this error message? at the moment trying to insert a new column between Y-Z and keep getting this error when it has nothing to do with column D.

 

[Fluff]

it has nothing to do with column D.

No, but it has something to do with the entire row. Also the code will check ALL criteria on that line, which will always give an error if more then one cell is changed.
Try adding this as the first line of code

   If Target.CountLarge > 1 Then Exit Sub

 

[RattlingCarp3048]

No, but it has something to do with the entire row. Also the code will check ALL criteria on that line, which will always give an error if more then one cell is changed.
Try adding this as the first line of code

   If Target.CountLarge > 1 Then Exit Sub

That worked. i havent seen that line before. what is saying?

 

[Fluff]

It sayd if more than one cell is changed, then exit the sub.

 

[RattlingCarp3048]

It sayd if more than one cell is changed, then exit the sub.

ah, ok. goo to know for future reference. thanks Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.