| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put current date into a cell when a macro is run
I want to set the value of a cell to the current date when a macro is run
without actually selecting the date (if possible). Here's what I'm trying to use and it's not working. . Dim LastPaid As Range Set LastPaid = wks.Range("N2") Set LastPaid = Value.Now() I know this is probably simple but it has me perplexed. Than ks Jonco |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run a macro in active cell only. Want to place current date/time. | Excel Worksheet Functions | |||
| Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
| save workbook as current date using a macro | Excel Discussion (Misc queries) | |||
| How do you set cursor position at current date in macro? | Excel Worksheet Functions | |||
| A macro for the today's date...not the current date | Excel Programming | |||
Threaded Mode
