15194| 18
|
[已解决]求解:利用vba取得所选任意区域的非空单元格,越快越好 |
5学分
最佳答案Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rng As Range
For Each rng In Target
If Len(rng) Then
If s$ = "" Then
s = rng.Address(0, 0)
Else
s = s & "," & rng.Address(0, 0)
End If
If Len(s) > 200 Then
Range(s).Interior.Color = vbRed
s = ""
End If
End If
Next
If Len(s) Then Range(s) ...
| |
发表于 2011-11-24 15:08
|
显示全部楼层
| ||
发表于 2011-11-24 15:48
|
显示全部楼层
| |
发表于 2011-11-24 15:55
|
显示全部楼层
| ||
发表于 2011-11-24 15:56
|
显示全部楼层
| |
| ||
发表于 2011-11-24 20:01
|
显示全部楼层
| |