Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'd like to automatically put the date into cell P2 whenever the data in cell
N2 is changed. I'd like to do the same for P3-N3. I found the VBA code to do this for a whole column, but I only want to do just these two indivual cells. I've tried the following, but doesn't work: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("N2")) Is Nothing Then Exit Sub Else P2 = Now() End If End Sub I know enough about VBA to be dangerous, so please try and be as detailed as possible in your suggestions. Many thanks, JIM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto date insert | New Users to Excel | |||
Auto insert Date & Time when another cell is populated | Excel Discussion (Misc queries) | |||
Auto insert date/time | Excel Worksheet Functions | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
Auto date/time insert when data entered into an adjacent cell | Excel Worksheet Functions |