I'm trying to figure a way to compare the previous row with the target
row in a worksheet_SelectionChange event
for example.

if previous row < target.row then
call macro
else
exit sub
end if

So my question is How would I go about determining the previous row?
Any help would be great. Thanks