How To Timestamp Changes To A Worksheet In Excel
In this tutorial we are going to look at how to create a timestamp whenever anything changes in a defined range of a worksheet.
To download the file and follow along, go to the link here:
https://app.box.com/s/gvjnenj8crnh5jv...
The VBA code that is used is:
Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1:D25")) Is Nothing Then
Range("H1").Value = Now
End If
End Sub
Remember, any file with macros or VBA code must be saved as a .xlsm macro-enabled workbook.
Do you need help with a formula or an Excel project?
You can send me an e-mail to [email protected]
Including a sample file is always helpful!
You can donate to my channel through any of the following:
PayPal:
https://paypal.me/ExcelBytes?locale.x...
Zelle or Venmo:
Send to [email protected]