Sub qwerty()
Dim rng As Range, r As Range, rSel As Range
Set rng = Range("B2:C7")
Set rSel = Nothing
For Each r In rng
If r.Value <> "" Then
If rSel Is Nothing Then
Set rSel = r
Else
Set rSel = Union(rSel, r)
End If
End If
Next r
If Not rSel Is Nothing Then rSel.Select
End Sub
2 回答
您的数据始终从B2,C2开始,中间没有空单元格?如果是这样,您可以将变量设置为“最后填充行”
并定义从B2到C“最后一行”的范围
使用循环:
如果要扩展要测试的区域,请使用: