I'm wanting to paste copied text into cell C9 and have a macro copy cell B9 and paste it's value back into B9 when I paste into C9. This is to lock in the date (since B9 is formatted NOW() and I'm needing to make it a constant). Any ideas???

Keyrookie