Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Start recording a macro. In the "Record Macro" dialog, change the macro name
to "Date_Time" (without the quotes), make the shortcut key CTRL+T (capital T), make sure it's stored in This Workbook, click OK. Stop Recording. Press ALT+F8, highlight Date_Time in the listbox, click Edit. Replace everything between the "Sub" and "End Sub" lines with ActiveCell.Value = Now Press ALT+Q to quit the VBE. Back in the worksheet, use the CTRL(+Shift)+T shortcut to call it. HTH, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Timeline with critical date markers | Charts and Charting in Excel | |||
Help with graphing log data | Charts and Charting in Excel | |||
How to exclude weekends/holidays from plotted time series | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |