Record entire row with changes

[robbydogg]

Hello,

I have tried searching for the answer to this but can only find how to record the specific cell change.
I'm looking for a bit of code that records the data from the entire row which has had a change in it.

So if row 3 has a change made in column e, then i need the data from the whole row to be place in a log sheet (beneith and previous entries) and so on.

can anyone help me with this of if there is already code available ?

thanks in advance.

 

[robbydogg]

ah brilliant, perfect!!! many thanks!!!

 

[MickG]

Just noted , The "End With" on the last but one line , shoud be on the next line.
Also seen you Latest Post, "Go it working"
I should try the new code, I think it will have less problems.
Mick