VBA／ListColumns : refer to a range of continuous columns

[smallxyz]

Let say, my Table Listobject ( named "T" ) has columns "AA","BB","CC", … "ZZ".
In worksheet, columns "AA" to "CC" could be referred using formula "=T[[AA]:[CC]]"

I wonder, if in VBA coding, there is similar way of doing so? Something like :

Dim L As ListObject
Set L = ActiveSheet.ListObjects("T")
L.ListColumns("AA:CC").Select ' This does not work. I tried.

（i.e. by specifying initial name and final name of the columns, the interim columns involved would all be referred )

Thanks.

 

[DanteAmor]

Try:

Sub Macro1()
    Range("T[[#All],[AA]:[CC]]").Select
End Sub

 

[smallxyz]

Try:

Sub Macro1()
    Range("T[[#All],[AA]:[CC]]").Select
End Sub

Thanks