The easiest way to create a macro is to record it. Turn on macro recording with
ToolsMacroRecord New Macro... When you're finished, hit the Stop Recording
button.

By the way, if you just want a static date or time, you can use Ctrl-Shift-Colon
or Ctrl-Shift-Semicolon instead.

--
Regards,
Fred


"Keyrookie" wrote in message
...

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




--
Keyrookie