excelperfect Sub LoopThroughAllTablesWorksheet() '创建变量来包含工作表和表 Dim ws As Worksheet Dim tbl As ListObject Set ws = ActiveSheet '遍历工作表中的每个表 For Each tbl In ws.ListObjects '这里是处理表的代码.... Next tbl End Sub
Sub LoopThroughAllTablesWorkbook() '创建变量来包含工作表和表 Dim ws As Worksheet Dim tbl As ListObject '遍历每个工作表 For Each ws In ActiveWorkbook.Worksheets '遍历工作表中每个表 For Each tbl In ws.ListObjects '这里是处理表的代码 Next tbl Next ws End Sub
Sub AddColumnToTable() '在末尾添加列 ActiveSheet.ListObjects('myTable').ListColumns.Add '在位置2添加列 ActiveSheet.ListObjects('myTable').ListColumns.Add Position:=2 End Sub
Sub DeleteColumnsFromTable() '删除第2列 ActiveSheet.ListObjects('myTable').ListColumns(2).Delete '删除名字指定的列 ActiveSheet.ListObjects('myTable').ListColumns('二月').Delete End Sub
Sub AddTotalRowToTable() '在显示最后一列带有值的汇总行 ActiveSheet.ListObjects('myTable').ShowTotals = True '为“汇总列”修改汇总为平均值 ActiveSheet.ListObjects('myTable').ListColumns('汇总列').TotalsCalculation = _ xlTotalsCalculationAverage '可以按位置而不是名称添加汇总 ActiveSheet.ListObjects('myTable').ListColumns(2).TotalsCalculation = _ xlTotalsCalculationAverage End Sub
Sub RemoveAutoFilter() ActiveSheet.ListObjects('myTable').ShowAutoFilterDropDown = False End Sub |
|
来自: hercules028 > 《VBA》