For some strange reason the following code is not working as I hoped. I want the code to run when only certain cells are changed (B4:B6). It runs though, when any cell is changed. What am I missing?
Code
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
Set rng = Combos.Range("B4:B6")
With rng
'This is just a simple code to use as a test
Range("A1").Copy
Range("G1").Select
ActiveSheet.Paste
End With
End Sub
Display More
Thanks for the help.