Hi All,
i have the below code which runs when a cells is populated (but only works when manually populated). i have cells that are either manually populated (which it words fine for) and some that are populated via a formula (which is does not work for). do i need to change the trigger to enable the VBA to pick up the cells populated via a formula? preferably an automatic solution would be best as these cells are hidden and is used to flag issues etc.
i have the below code which runs when a cells is populated (but only works when manually populated). i have cells that are either manually populated (which it words fine for) and some that are populated via a formula (which is does not work for). do i need to change the trigger to enable the VBA to pick up the cells populated via a formula? preferably an automatic solution would be best as these cells are hidden and is used to flag issues etc.
Code:
Private Sub Worksheet_Open(ByVal Target As Range) If Target.Column = 11 Or Target.Column = 13 Then 'Column I or column M
If UCase(Target) = "YES" Then Target.Offset(0, -1).ClearContents
End If
End Sub