在Excel表中选择多个列的代码 [英] Code to Select Multiple Columns in an Excel Table
本文介绍了在Excel表中选择多个列的代码的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想在excel表中选择多个表列。
这是我的代码:
Dim ws As Worksheet
Dim tbl As ListObject
设置ws = Sheets(Sheet1)
设置tbl = ws.ListObjects(1)
范围(tbl [[Column1]:[Column5]])选择
当我把表名称,它是有效的。但是我想使用我在代码中使用的变量来选择表列。
解决方案
可以使用连接来使用一个变量作为表名。
这是代码:
Dim ws As Worksheet
Dim tbl As ListObject
设置ws = Sheets(Sheet1)
设置tbl = ws.ListObjects(1)
范围(tbl& [[Column1]:[Column5]])。选择
I am new to Excel VBA. I need a modification in my code so that I would be able to proceed further.
I want to select multiple table columns in an excel table. Here is my code:
Dim ws As Worksheet
Dim tbl As ListObject
Set ws = Sheets("Sheet1")
Set tbl = ws.ListObjects(1)
Range("tbl[[Column1]:[Column5]]").Select
When I put the table name, it works. but I want to use variable which I have used in my code to select the table columns.
解决方案
You can use concatenation to use a variable as a table name.
Here is the code:
Dim ws As Worksheet
Dim tbl As ListObject
Set ws = Sheets("Sheet1")
Set tbl = ws.ListObjects(1)
Range(tbl & "[[Column1]:[Column5]]").Select
这篇关于在Excel表中选择多个列的代码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文