MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.