Macro help

K

Keyrookie

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
 
F

Fred Smith

The easiest way to create a macro is to record it. Turn on macro recording with
Tools>Macro>Record 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.
 
Top