Hello all,
In the following code if the change in value occurs in range M5:M1000 the code will run. However, this is true with any value change. What if I would like to neglect the code operation from change code if the value in that range (M5:M1000) begin with a "(" bracket. And thus do nothing if this case is true.
Thanks and will appreciate.
In the following code if the change in value occurs in range M5:M1000 the code will run. However, this is true with any value change. What if I would like to neglect the code operation from change code if the value in that range (M5:M1000) begin with a "(" bracket. And thus do nothing if this case is true.
VBA Code:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim KeyCells As Range
Set KeyCells = Range("M5:M1000")
If Not Application.Intersect(KeyCells, Range(Target.Address)) _
Is Nothing Then
Thanks and will appreciate.