Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code, which works terrificially.
Private Sub Worksheet_Change(ByVal Target As Range) Const WS_RANGE As String = "F18:F450" On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target If .Value < "" Then .Offset(0, -5).Value = Format(Date, "dd-mmm-yyyy") End If End With End If Const WS_RANGE_1 As String = "F18:L450" On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE_1)) Is Nothing Then With Target If .Value < "" Then Range("B2").Value = Format(Date, "dd-mmm-yyyy") End If End With End If ws_exit: Application.EnableEvents = True End Sub I use it to update a cell with the current date when something in the specific range changes. What I normally do on this particular sheet is to paste values in, because others update the information on the spreadsheet. What I would like to happen is that when I paste information in from the clipboard that the date in B2 gets updated with the current date after the paste. What do I need to do to modify my code to allow that to happen? thanks for letting me know. Terry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How will hyperlink cell reference update after copy paste? | Excel Worksheet Functions | |||
Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
Need to paste/update info to correct row. | Excel Programming | |||
Update value of variable from one sheet to paste into another shee | Excel Programming | |||
Paste Functions and Update info | Excel Worksheet Functions |