Hi, if the value of E7 changes then the target address as you called it
will be equel to "$E$7". If you want "E7" to be returned use:
Target.Address(False, False)

You then need to test the target cell as to whether it exists within
your required range.

HTH--Lonnie