Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sorry, very new to formulas and code. The code below will populate a cell
with the update date/time when the cell next to it is updated. Works GREAT...on that one cell! How do I apply this code to an entire column? I'm sure I need to enter a range of cells somehow into this code but I don't know how to do this. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$D$7" Then Target.Offset(0, 1) = Format$(Now, "dd/mm/yy hh:mm") End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clarification - how to automatically update cells with a date and date range | Excel Discussion (Misc queries) | |||
how to make auto date update work on a range of cells. | Excel Programming | |||
Auto Sum a Range of Cells based on the date | Excel Discussion (Misc queries) | |||
How do I make a name formula auto update in Excel | Excel Worksheet Functions | |||
Auto refresh and DDE update is not work when running macro | Excel Programming |