Fix change event code to add todays date when data is added to multiple cells in column

I have some Change event code which among other things adds todays date into D when data is first entered into G.
The issue I'm having is when I paste data into more than one G cell at the same time it doesn't work. How can I fix this?

Please Login or Register  to view this content.

Here:

Please Login or Register  to view this content.

you force the procedure to quit if there is more than 1 changed cell. change it to:

Please Login or Register  to view this content.

few lines later it is again (useless, because if the condition were met it would never be executed) so delete:

Please Login or Register  to view this content.

and ... I am reading with further on several times checking again.

Ok. I'll try to suggest complete final version (no attachment, so not tested)

Please Login or Register  to view this content.

I wrote it without testing, so check syntax, etc.

Summarizing: As I said - remove all checkin of target.cells.count
In all cases where action on target shall be made cell by cell just do it - for each cell in target (or subset of target) do something.

Thank you Kaper that fixed it.
Im not very experienced when it comes to VB, is there something further that your recommending I do to fix up the code?

Hi,
I am glad it hepled.
I do not really see the point to react on any changes out of column G (the three special cases are all about some change in column G). So may be you could narrow the field here:

Please Login or Register  to view this content.

for instance to

Please Login or Register  to view this content.

Once you do it (or even if not) here

Please Login or Register  to view this content.

you start from G2. If the changed range is simply G2 this part will never be executed, because of the first checking whether target intersects with G6:G_last_

So it is probably right to write:

Please Login or Register  to view this content.

if you do not expect that

Please Login or Register  to view this content.

is different (lower row number) than

Please Login or Register  to view this content.

which is checked just at the beginning you could change also this part.