|
- Option Explicit
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Dim i, j, k, l, x, y As Integer
- Dim arr, brr
- Dim d As Object
- Dim rng As Range
-
- x = Target.Rows.Count
- y = Target.Columns.Count
- Set d = CreateObject("scripting.dictionary")
- If x > 0 And x < 30 And y > 1 And y < 30 Then
- arr = Target
- For i = LBound(arr) To UBound(arr)
- For j = LBound(arr, 2) To UBound(arr, 2)
- If Len(arr(i, j)) > 0 Then
- d(arr(i, j)) = d(arr(i, j)) & "连"
- End If
- Next
- brr = d.keys
- For Each k In brr
- If Len(d(k)) > 1 Then
- For Each rng In Range(Target.Cells(i, 1), Target.Cells(i, y))
- If rng.Value = k Then
- rng.Interior.Color = vbGreen
- End If
-
- Next
- End If
- Next
- d.RemoveAll
- Next
- ElseIf y = 1 Then
- For Each rng In Target
- If rng = "" Then
- Exit Sub
- End If
- Next
-
- End If
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|