View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default 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.