Macro help

  • Thread starter Thread starter Keyrookie
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drag Down Formula Incorrect 3
If, but, and still but, all in one formula? 2
Countifs with different restrictions 1
IF and OR functions to obtain text descriptions 1
Find & Search Function 6
Multiple AND OR functions 5
Subtracting positive amts from negative and positive from positive 3
Do I want to create a Circular references 4

Back
Top