| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Macro help
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro help
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Linear Mode
