- ·上一篇：excel表格如何交换序列顺序
- ·下一篇：在Excel里如何算极限
如何在excel条件塞选
2026-01-07 10:14:37
1.Excel中如何同时选中满足特定条件的行或列
可用以下VBA程序快速选定：
Sub 选A列等于1()
Dim rag As Range, rags As Range
For Each rag In Range("A:A")
If rag.Value = 1 Then
If rags Is Nothing Then
Set rags = rag
Else
Set rags = Union(rags, rag)
End If
End If
Next
rags.Select
End Sub