Worksheet_change, how to detect a range is changed instead only 1 cell?

[vin1]

like the title says. i am trying to check if the target is either a range or only 1 cell.

I have a little code that says

Please Login or Register  to view this content.

But when target are multiple cells the same time, this line ends up with an error.
Hoe can i detect wether it were more then 1 cells that were changed?

After it i want to: EnableEvents = false, application.undo, msgbox "Change 1 cell at the time" and EnableEvents = true

[Andrew-R]

Please Login or Register  to view this content.

Will return how many cells have been changed.

[vin1]

thanks that will do.

Somethimes the answer is very simple, but you just have to know it