Need help with the vba code able to record the changes of the whole row of cell

Hi

I need to modify the code to allow the excel sheet 1 or etc which allow to
paste the whole row of cell and record the changes in the Log tab.

Currently the code can only able to record the amendment in individual cell.

I really hope someone can help me.

AttachmentSize
AuditLog.xlsm31.83 KB