I have this worksheet change below that works well. I'd like to amend it so it works across worksheets if possible. I'm just not sure how to do this or where to place this in the project(I'm guessing in This Workbook???). I obviously need to add the different worksheet names to each of the ranges so not certain I know how to do that properly either.
Any help would be fantastic - I'm a bit new to VBA.
Any help would be fantastic - I'm a bit new to VBA.
VBA Code:
Private Sub WorkSheet_Change(ByVal Target As Range)
If Target.Address = Range("c12:c46").Address Then
Range("$j$2").Value = "Please Select..."
End If
End Sub