Can someone help with this example? Thx
Posted by Johan on January 09, 2002 7:08 AM
Anyone know how to include more than 1 cell (C1)? Example C1 to C50
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$1" Then Target.Offset(0, 2).Value = Now
End Sub
Thx
Posted by Dan on January 09, 2002 7:30 AM
If Target.Column = 3 And (Target.Row >= 1 And Target.Row <= 50) Then Target.Offset(0, 2).Value = Now
Posted by Johan on January 09, 2002 8:19 AM
Dan,
Just wanted to say thank you.
