Hi.
The code below triggers a Macro on a SPECIFIC sheet............but I have 40 sheets. Can the code be altered to work on all of them?
Many thanks
Morris...........hopefully not a daft question this time
Sub worksheet_change(ByVal target As Range)
Set target = Range("A1")
If target.Value = "Delete" Then
Call Macro1
End If
End Sub
The code below triggers a Macro on a SPECIFIC sheet............but I have 40 sheets. Can the code be altered to work on all of them?
Many thanks
Morris...........hopefully not a daft question this time
Sub worksheet_change(ByVal target As Range)
Set target = Range("A1")
If target.Value = "Delete" Then
Call Macro1
End If
End Sub