请教EXCEL VBA中的一个问题

2025-04-13 17:09:39
推荐回答(1个)
回答1:

Sub 选择整列()
Dim rng As Range, rt As Range
For Each rng In Selection
If rng <> "" And rng = 0 Then
If rt Is Nothing Then
Set rt = rng.EntireRow
Else
Set rt = Union(rt, rng.EntireRow)
End If
End If
Next
rt.Select
End Sub