Hi I wonder if anyone can help me out. My macro's use to run automatically based on a change to cell H6, is there any way to target the whole sheet or more than one cell to automate the macro's as the sheet is continually changing and more than one cell is affected by the macro's.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value = "$H$6" Then
Buy
Sell_Number
Going_Long
Going_Short_Premium
PlayIt
Long_Discount
Buy_Value
Sell_Value
testSound
Resistance
Support
End If
End Sub
Thanks
Bookmarks