Worksheet _Change

[peternugent50]

Hi, I am trying to put some basic VBA onto my spreadsheet. I have entered the below code, and when I manually update cell F2 to "Closed" the code works.

If I wait for BA to update the cell with the same text there is no response. Is there something I need to enable to allow the Worksheet _Change to operate when BA updates my spreadsheet?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$F$2" Then

If [$F$2].Value = [$A$100].Value Then

Range("Q2").Select
ActiveCell.FormulaR1C1 = "-1"

Range("T5:Y54").Select
Selection.ClearContents

End If
End If

End Sub

[MarkRussell]

Please see http://www.gruss-software.co.uk/forum/viewtopic.php?t=5132
Regards,
Mark

[peternugent50]

Thanks Mark, all sorted!

Peter