I am watching a specified range to see if there's any change in any of the entry by using worksheet_change event.

I proceed to compare the target range with my specified range to see if it falls within my range.

For that I use intersect to pick up the list of elements in it but I am not sure how to also list out the index of those elements relative to my specified range.

For example, my specified range is A5:A9 & element A7 has undergone a change, I want to be able to say element 2 has been selected.
I am thinking of two ways (a) using Match to get that (b) do subtraction of row from base address of my specified range.

However, I am wondering if there's anything with the class definition of range that I could get that information without going through all these computations.

Any suggestions?