本帖最后由 suye1010 于 2013-10-22 20:18 编辑
Sub DelCol()
Dim sh, FText, Foundrng
FText = InputBox("请输入要删除列的字段名称", "删除内容", vbOKCancel)
If Len(FText) Then
For Each sh In ThisWorkbook.Sheets
Set Foundrng = sh.Range("A2:G2").Find(FText)
If Not Foundrng Is Nothing Then
Foundrng.EntireColumn.Delete
End If
Next
End If
End Sub