How do you get the next Target.Address?

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.

Please Login or Register  to view this content.

Thanks for the help guys.

George