Forum Home
Press F1
 
Thread ID: 104724 2009-11-06 06:55:00 Live times for excel? rob_on_guitar (4196) Press F1
Post ID Timestamp Content User
827679 2009-11-18 06:59:00 Try This

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

MyRange = ("A10:A15,C16:C20")

If Not Intersect(Target, Range(MyRange)) Is Nothing Then

Target = Now()
End If

End Sub
TeejayR (4271)
827680 2009-11-18 19:30:00 'O' for Awesome!
Choc fish all around!
rob_on_guitar (4196)
1 2