Do you need something in addition to the responses here?

http://www.microsoft.com/office/comm...b-c4560e78778a

Barb Reinhardt

"John" wrote:

I tried posting this on Saturday and I think it got lost in the
problem google was having since I don't see it now that the log jam
appears to have been broken. My apologies if this is a duplicat post.

Is it possible for VB to determine what was the last cell that was
changed, that is the last cell that had data typed into it not by a
macro? Excel must know where this cell is located in order to execute
the undo command, I just want to know if VB can dtermine the location
of this cell. I want to be able to change a cell in the same row as
this last changed cell.

Thanks