The general idea is to run a macro when a cell changes.

I have figured out a workaround for now, using the Worksheet_Change object,
but is there any way to find out which cell has been altered?

We have Target as a ByVal, but thats the .value of the cell thats been
altered. How do I know the cell's reference?

TIA.