|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
'去除可能出现的叠加区域,左、下方向搜索,不用方向结果不一定相同,,,
Option Explicit
Sub test()
Dim arr, i, j, k, kk, x, y
arr = [a1:ax61].Value
x = [bg6].Value: y = [bg8].Value
[a1].Resize(UBound(arr, 1), UBound(arr, 2)).Interior.ColorIndex = xlNone
For i = 4 To UBound(arr, 1) - x + 1
For j = 6 To UBound(arr, 2) - y + 1
If Len(arr(i, j)) = 0 Then
For k = i To i + x - 1
For kk = j To j + y - 1
If Len(arr(k, kk)) > 0 Or Cells(k, kk).Interior.Color = vbRed Then Exit For
Next
If kk < j + y Then Exit For
Next
If k = i + x Then Cells(i, j).Resize(x, y).Interior.Color = vbRed
End If
Next
Next
End Sub |
评分
-
2
查看全部评分
-
|