View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Phrank Phrank is offline
external usenet poster
 
Posts: 153
Default 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.


Oh, I did not realize that. Ok, I'll take a look. Thank you!

Frank