VBA audit trail - trap and handle not work

Hello,

i have this code and he works good ,but when i use trap and handle cell, only the first value is logged to audit trail.

Would you help me please?

THANKS!

Please Login or Register  to view this content.

Oh sorry,

Audit trail log all changes in sheet (exclude changes from blank cell) with address, user, date/time, old value, new value.

Trap and handle I think black cross in right bottom corner of cell.

When you use the fill handle (when the cursor turns to a black +) to fill cells down, it expands the range and updates the cells in one atomic action. However, two events occur. First the SelectionChange event occurs, because you expanded the selection. In your code, this event causes PreviousValues to be updated, but it happens after the values on your worksheet have already been updated. So the code in Change thinks that there has been no change.