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 |
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 |
All times are GMT +1. The time now is 10:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com