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