Sub demo()
Set Rng = [zz:zz]
On Error Resume Next
Set r = Cells.Find("序号")
first = r.Address
Do
Set r = Cells.FindNext(r)
Set Rng = Union(Rng, r.EntireColumn.resize(,2))
Loop Until r.Address = first
Rng.Select
End Sub
Sub demo()
Set Rng = [zz:zz]
On Error Resume Next
Set r = Cells.Find("序号")
first = r.Address
Do
Set r = Cells.FindNext(r)
Set Rng = Union(Rng, r.EntireColumn)
Loop Until r.Address = first
Rng.Delete
End Sub
Sub demo()
Set Rng = [zz:zz]
On Error Resume Next
Set r = Cells.Find("序号")
first = r.Address
Do
Set r = Cells.FindNext(r)
Set Rng = Union(Rng, r.EntireColumn.resize(,2))
Loop Until r.Address = first
Rng.Select
End Sub