I am creating a new sheet programatically, and would like to add this event to the new "Activesheet" programatically.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Row = 5 And Target.Column = 4 Then
ActiveCell.Offset(-1, 2).Activate
End Sub
I have looked and looked and I just cant find anything.
Many Thanks in Advance...
Rob
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Row = 5 And Target.Column = 4 Then
ActiveCell.Offset(-1, 2).Activate
End Sub
I have looked and looked and I just cant find anything.
Many Thanks in Advance...
Rob