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