Auto copy and paste value

Hi

This is driving me up the wall so I hope someone can help me.

I am using the code below to copy a row from one sheet to another sheet and also lock the original row.

The code works as it should but when the row is pasted into the new sheet it keeps all the formulas etc and I just want the value/text.

Please Login or Register  to view this content.

Can someone help me with the missing code please


Processchip