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?
Bookmarks