| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help + date
I have a button that basically approves jobs, i need a line of code that when
pressed will automatically insert the current date into 4 separate cells within the excel sheet. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Help + date
range("A1")=Date "Neil Holden" wrote: I have a button that basically approves jobs, i need a line of code that when pressed will automatically insert the current date into 4 separate cells within the excel sheet. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Help + date
Range("A1,C1,E1,G1") = Date()
If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: I have a button that basically approves jobs, i need a line of code that when pressed will automatically insert the current date into 4 separate cells within the excel sheet. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to date stamp to the right of the macro command button | Excel Programming | |||
| Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
| Date Macro if B is populated then date in A | Excel Programming | |||
| Date Macro | Excel Discussion (Misc queries) | |||
| A macro for the today's date...not the current date | Excel Programming | |||
Linear Mode
