|
本帖最后由 苏子龙 于 2016-9-5 12:40 编辑
Private Sub Worksheet_SelectionChange(ByVal Tg As Range)
Application.ScreenUpdating = False
Dim arr, x%, y%
With Tg
If .Row > 37 And .Row < 3 Then Exit Sub
If .Column > 18 And .Column < 3 Then Exit Sub
If .Count > 1 Then Exit Sub
End With
For x = 3 To 37
For y = 3 To 18
If Cells(x, y) = Tg Then
Cells(x, y).Interior.Color = 13395711
Else
Cells(x, y).Interior.ColorIndex = 0
End If
Next y
Next x
Application.ScreenUpdating = True
End Sub
|
评分
-
查看全部评分
|