The argument of the change function is Target as Range and that is the cell
that was just changed... Add this code to your change event to see what I mean

msgbox "Cell " & target.address & " was changed to " & target.value


--
HTH...

Jim Thomlinson


"HRman" wrote:

I have a spreadsheet that users may update. When they do update a value, I
want to check that it falls within certain ranges dependant on other cells in
the sheet (so I can't use the data validation function). I am using
worksheet_change which works OK in terms of detecting a change, but how can I
find out which cell they have changed. I tried using activecell, but that
does not work if they move to another cell using the mouse, rather than
pressing return. Any Ideas

Thanks