使用列号删除多个列 [英] Delete multiple columns using column numbers

问题描述

只需要分享，因为我有很多麻烦寻找在线方式，终于得到了一系列的试错。

Just wanted to share as I had huge amount of trouble looking for ways to do this online and have finally gotten it through series of trial and error.

Sheet1。范围（单元格（1，11），单元格（1，100））。EntireColumn.Delete

Sheet1.Range(Cells(1, 11), Cells(1, 100)).EntireColumn.Delete

这将删除列11到100。

This deletes columns 11 to 100.

推荐答案

With Sheet1
    .Range(.Cells(1, 11), .Cells(1, 100)).EntireColumn.Delete
End With

这篇关于使用列号删除多个列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！