Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Okay,
I think I finally figured out what I was doing wrong. To make a long story short, this works great! THANK YOU ALL FOR YOUR ASSISTANCE!! ga Gary''s Student wrote: Hi George: Enter this into worksheet code: Sub Worksheet_Change(ByVal Target As Excel.Range) If Intersect(Range("A2:A10"), Target) Is Nothing Then Exit Sub Application.EnableEvents = False Range("A1").Value = Now() Application.EnableEvents = True End Sub The routine will activate if cells in the range A2 thru A10 are changed via editting. When the change occurs, the date/time is deposited in cell A1. REMEMBER: worksheet code George Applegate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum Product Function Question | Excel Discussion (Misc queries) | |||
DB (depreciation) function Help question | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
INDIRECT function question | Excel Worksheet Functions | |||
Function question | Excel Worksheet Functions |