Hi Dave,

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


Target *is* the changed cell(s), so Target.Address yields its address and
Target.Parent.Name gives you the name of the worksheet that cell lives
in.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com