How to select Multiple columns in a table using Macro

[sreekhosh]

Hi,

I have a table containing more than 10 Headers. How to select and copy multiple headers at a time using macro.

I need to copy below Headers from my table.

Account Name, Cleint Name, Eng Number, Revenue.

I am using below code for selecting single column header,

Range("Table1[Account Name]").Select


Regards

Sreekhosh

 

[kchiba]

Hi

Put a comma between your Headers as such:

Range("Table1[aa],Table1[bb]").Select
regards

kanti

 

[sreekhosh]

Thanks Kanti,

I also tried the same. But is there any way to do the same with out repeating table name (ie: "Table1").

Thanks
Sreekhosh

 

[SirJB7]

Hi, sreekhosh!
Tried this?
Range("Tabla1[[#Headers],[Account Name]:[Revenue]]").Copy Worksheets(2).[C5]
Adjust output as required.
Regards?

 

[sreekhosh]

Hi SirJB7,

Thank you for the effort.

but i got Runtime Error '1004' Method range of object Global failed.

Regards
Sreekhosh.

 

[SirJB7]

Adjust output as required.

Hi, sreekhosh!
I used my table name (Tabla1), any output address (cell C5 on 2nd worksheet). Have you tweaked them as indicated?
Regards!