Worksheet_Change (ByVal Target As Range)

[oliverliu2]

Dears,

I used the following code the check if more than one cell is changed at once.

Please Login or Register  to view this content.

Due to the work relationship, I need to copy a series of cell data and paste it, then VBA stops. I need to close the workbook and open it again to get back to normal.
What code can I use to solve or run in parallel?

[Greg M]

Hi there,

Without seeing your entire code it is impossible to determine what the problem is.

Your test causes a very "abrupt" termination of the routine, and I suspect that something (e.g. Application.EnableEvents) needs to be reset before exiting from the routine. Can you provide further information?

Regards,

Greg M

[oliverliu2]

Dear Greg M,

Below is the code.

Please Login or Register  to view this content.

Regards,

Oliver

[Fluff13]

How about

Please Login or Register  to view this content.

[oliverliu2]

Dear Fluff13,

It works.
Besides, the code is used for one cell change. How about if more than one cell change at the same time (copy & paste)?

Regards,

Oliver

[Fluff13]

How about

Please Login or Register  to view this content.

[oliverliu2]

Dear Fluff13,

Perfect!
This is the great answer.

Regards,
Oliver

[Fluff13]

You're welcome & thanks for the feedback.