Do you mean you want to compare the entire two rows to see if the contents are identical, or that you just want to compare the row
numbers ?

--
Tim Williams
Palo Alto, CA


wrote in message oups.com...
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