Does the following do what you need?
hth![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 6 And (25 <= Target.Row <= 225) Then Target.Interior.ColorIndex = 38 End If End Sub
Ajay
Does the following do what you need?
hth![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 6 And (25 <= Target.Row <= 225) Then Target.Interior.ColorIndex = 38 End If End Sub
Ajay
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks