Worksheet Change event question
On Tue, 1 Mar 2016 13:34:18 +0100, Claus Busch
wrote:
Hi Frank,
Am Tue, 01 Mar 2016 07:31:43 -0500 schrieb Phrank:
The problem is the worksheet change event sees the 'ActiveCell' as the
cell to the right or below the cell where the number was entered.
don't work with ActiveCell. Work with Target. Target is the cell that
has been changed.
Regards
Claus B.
Hi again. Just wanted to follow up. That was so brilliantly simple.
I'm all set now. Thank you!
Frank
|