Refer to multiple columns in a listobject (VBA)

[Durrant_Bun]

I know it's probably really simple and I'm just being a bit thick, but how do you refer to more than one column in a listobject in VBA???

So I have a listobject with 6 columns, and I want to do a vlookup to look at columns 3 to 6. I have googled and googled but can't find an answer!

Thanks

 

[RoryA]

For a contiguous range like that, you can just refer to the first one and then resize the result like this:

Activesheet.Listobjects(1).Listcolumns(3).Databodyrange.Resize(, 4)

 

[Durrant_Bun]

Got it, thanks!