Because the target cell is a formula, the change event doesn't occur when
cells change during a recalculation.
--

Regards,
Nigel




"Barry Lennox" wrote in message
...
Can anyone tell me why this macro does not run when cell value changes

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$2" Then Call Refresh

End Sub

Formula in "A2" is =Entry!$K$2 ("Entry") is anothe worksheet in same
workbook

Barry