Function to Identify the Modification of a Worksheet
I would like to add a function to a worksheet that would identify "last
modification date" of a specific range. |
Function to Identify the Modification of a Worksheet
You would need a macro to be placed in the code module of the worksheet
containing the range. Something like: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C1:D10")) Is Nothing Then Range("A1") = Date End Sub __________________________________________________ _________________________ "Penny" wrote in message ... I would like to add a function to a worksheet that would identify "last modification date" of a specific range. |
All times are GMT +1. The time now is 06:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com