如何在QueryTable中选择最后一列作为范围（Excel宏）(how to choose the last column as the range in QueryTable (Excel Mac

如何在QueryTable中选择最后一列作为范围（Excel宏）(how to choose the last column as the range in QueryTable (Excel Macro))

我想使用QueryTable.Add将多个表彼此相邻导入

如何在范围内自动选择最后一列：

With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://www....html", Destination _ :=Range(??????)) <---- Here

先谢谢你！

I want to import multiple tables next to each other using the QueryTable.Add

how do I choose the last column automatically in the range:

With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://www....html", Destination _ :=Range(??????)) <---- Here

Thank you in advance!

最满意答案

With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://www....html", Destination _ :=ActiveSheet.Cells(X,LCol))

X标记该行

With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://www....html", Destination _ :=ActiveSheet.Cells(X,LCol))

X marks the row