Sub 选择整列()Dim rng As Range, rt As RangeFor Each rng In SelectionIf rng <> "" And rng = 0 ThenIf rt Is Nothing Then Set rt = rng.EntireRowElse Set rt = Union(rt, rng.EntireRow)End IfEnd IfNextrt.SelectEnd Sub