Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am using the Sub shown below.
Question: How do I determine the address of the changed cell? Private Sub Worksheet_Change(ByVal Target As Range) Dim WatchRange As Range Dim IntersectRange As Range Set WatchRange = Range("E1:E31") Set IntersectRange = Intersect(Target, WatchRange) If IntersectRange Is Nothing Then 'MsgBox "Changes occured outside of range" Else 'MsgBox "You modified the selected range of cells" Application.Run "Test.xls!Time_Stamp" End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
look up a value that results in a cell address | New Users to Excel | |||
Help Pls re macro cell address | Excel Discussion (Misc queries) | |||
How do I dynamically retrieve the cell address of the last cell t. | Excel Discussion (Misc queries) | |||
How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |