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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional