VBA code for audit trail issue

[TheGrinch1]

Hi,

Not sure if this will be possible - I have a workbook in which vba is used to record changes made on one sheet onto another sheet called 'log'.

The code works fine when people make changes in cells one at a time but if they paste in data to more than one cell at once I get a run time error '13'.

So the code I am using on the sheet where the changes are is:

Please Login or Register  to view this content.

The code on the log sheet is:

Please Login or Register  to view this content.

Any ideas how I can enable the changes to be logged if more than 1 cell is changed at once? Thanks in advance for anyone taking the time to look at this.

[TheGrinch1]

My apologies, I have now amended my post accordingly, thanks for pointing out the error.

[LordLoki]

Why do you not Share the Workbook and Enable Track Changes?
Then you dont need any VBA to Track changes

Greets
Loki

[TheGrinch1]

Hi LordLoki,

I really need to do it through VBA, its par of a wider piece and I have gone down this road now - plus I am trying to better myself at VBA and understand it more and so understanding how I can convert my original code to allow for this adaption will help me further my knowledge. Thanks for your suggestion though.

[Kramxel]

I did something similar with some help from the forumites here. (try my thread for some pointers http://www.excelforum.com/showthread...t=#post4059392)

[TheGrinch1]

Hi Kramxel,

Thanks for pointing me to your thread. Reading through it I am not sure it solves my issue - my code works fine as it is up until two cells plus are amended at the same time (by someone pasting in data), at this point the logger fails. I cannot see that resolved in yours, however I will work through your thread more thouroughly to double check this. Appreciate the help though.

[LordLoki]

Hi Grinch,

In case you did not solve your problem here is a solution.
Its not very beautiful but it works

Please Login or Register  to view this content.

[TheGrinch1]

That is superb, works a treat - thank you very much, I was still having problems with it.