Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Go to function to identify dependent cells between worksheets | Excel Worksheet Functions | |||
Need to identify active worksheet in macro | Excel Worksheet Functions | |||
last modification | Excel Discussion (Misc queries) | |||
Identify end of data in worksheet, prevent overshoot | Excel Discussion (Misc queries) | |||
Macro Modification Help | Excel Worksheet Functions |