Hi guys,
I have an event that triggers when the user changes a cell in a worksheet.
The Subroutine checks if cell changed is in column A and greater than row 13. Is there a smarter way to do this rather than using Split?
How do you get the next Target.Address? For example, if I change cell A14 Target.Address = $A$14 then the next Target.Address would be $A$15.
Private Sub Worksheet_Change(ByVal Target As Range)
x = Split(Target.Address, "$")
If x(1) = "A" And CInt(x(2)) > 13 Then
' Get next target address
' Execute other code
EndIf
End Sub
Thanks for the help guys.
George
Bookmarks