View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barry Lennox[_2_] Barry Lennox[_2_] is offline
external usenet poster
 
Posts: 29
Default Macro wont run on cell change

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