Ah, J245 isn't changing, because the formula in the cell is the same. There
are a couple of ways to capture changes to the value calculated by the
formula in J245.

You could use the precedents of J245 as the target cells of interest.

You could save the value of J245 in another cell (say, K245) and use the
Worksheet_Calculate event as your trigger instead. If J245 = K245, there's
no change, so exit. Otherwise, put the new value of J245 into K245, then
perform the action you want to happen when J245 changes in value.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"gordom" wrote in message
...
Thanks guys for your help. I tested the delay codes and
they work fine. Nevertheless my problem is not solved
yet. There is some more issue that didn't notice before.
The Target.Address ("$J$245") refers to the cell that
contains formula. However the value in the cell changes
the formula stays the same. It means that there is no
trigger for the "Private Sub Worksheet_Change(ByVal
Target As Range)" event. The possible values of the
$J$245 cell are unknown. Could you please help me with
this matter also (sorry but I'm very much a novice in
VBA). Thanks,
gordom