Showing last editing date
I was wondering if there is a way to have one cell show the date of when
another cell was last edited. |
You can use a change event. Assume you want cell B1 to track when last A1 was
changed. Right click sheet tab, select View Code and paste the macro below: Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ErrorHandler Application.EnableEvents = False If Target.Address = "$A$1" Then Range("B1").Value = Date End If ErrorHandler: Application.EnableEvents = True End Sub Hope this helps Rowan "Kenny" wrote: I was wondering if there is a way to have one cell show the date of when another cell was last edited. |
All times are GMT +1. The time now is 06:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com