You can look at the change event. The Target argument is a reference to the
cell that triggered the event.

http://www.cpearson.com/excel/events.htm
Chip Pearson's page with an overview on events.

--
Regards,
Tom Ogilvy

"Randy" wrote in message
...

--
Randy

Hi, I am having trouble getting the row number of the cell just modified.

If Copy/Paste is used, ActiveCell.Row gives the correct answer. If the
cell
was cleared with the DEL key, again AC.Row is correct. Problem is the if
the
cell was modified and then ENTER is hit, AC.Row now gives me the next row
number. I need to know the real row that was modified so I can do some
stuff
to other cells on that row. This is probably easy but I can't find it.

Thanks.