Worksheet change event

[merry_fay]

Hi,

I'm trying to run an event on the cell that has been changed in a worksheet change event.
This works in my excel where I don't move the cursor after enter, but when my colleagues use it, it then looks at the wrong cell because they move after enter.

Is there a way to say 'go to the last cell changed'?

I've got the code for Application.MoveAfterReturn = False but this will leave their setting changed (or if I set it back to true, change mine!!).

Thanks
merry_fay

 

[merry_fay]

I think it is you who are not getting the point.
The Change event provides you a range object called Target as an argument. This is the cell(s) that has (have) been changed. You need to refer to Target in your code and not to Activecell.
Once again, if you posted the code this would be much simpler...

Nope, that's all I was asking for, a way to refer to the cell changed.

Target was all I needed. Target.Select has fixed it for me!

Thankyou

 

[RoryA]

That was simply reiterating what I said here.