worksheet change tracking...
 

Hi.

I'm trying to track some info when a change is made in a
worksheet. Using the worksheet_change event, by the time
you get into the code, the Activecell is the newly
selected cell.

For instance, if you make a change in the range A1:E1, if
you hit enter to register the change, the cursor is still
in row 1, and the code works fine. The activecell is in
row 1.

However, if the user use the mouse to select another row,
say cell A18, by the time the event is fired, the
activecell is in row 18.

Can someone suggest a good way to access the row number
prior to the selection change?

Thanks.