On Jul 3, 3:46 pm, wrote:
Hi,
I have set Worksheet_Change up OK for a sheet, so it is called
whenever a value changes. The problem is that it gets called even if
a value does not change. So, for example, if I have 7 in cell A1, and
then retype 7 in A1, Worksheet_Change is called, although no value
changed in the worksheet. Is this the way Worksheet_Change works? Is
there a way to change it? Failing that, is there a way I can tell
once I'm in Worksheet_Change that the change was not really a change?

Thanks in advance,
Philip.

Hello Philip,

Worksheet_Change fires whenever a cell's value changes, either by the
user or external link. Worksheet_SelectionChange fires whenever you a
cell is selected

Sincerely,
Leith Ross.