copy multiple column, including headers, to a new sheet

[boboivan]

Hi everybody!

I have this partial code to copy some columns from a table in WS and past only the values in WS1

Please Login or Register  to view this content.

What should I add to the code to past values of the column including the headers?

Thanks!

[Naveed Raza]

Could you please provide columns Nbrs

mean while u can try this sample

Please Login or Register  to view this content.

[boboivan]

Could you please provide columns Nbrs

Column's 2 name is = Reg. no.
Column's 3 name is = Date of reg.
Column's 10 name is = Content
Column's 16 name is = No. of pages
Column's 17 name is = Interval

[Naveed Raza]

Column's 2 name is = Reg. no.
Column's 3 name is = Date of reg.
Column's 10 name is = Content
Column's 16 name is = No. of pages
Column's 17 name is = Interval

try this

Please Login or Register  to view this content.

[boboivan]

Could you please provide columns Nbrs

mean while u can try this sample

Please Login or Register  to view this content.

Works, but if I use EntireColumn.Copy, I'll have over 20000 pages to print from my new sheet .
I need to paste in the new sheet only the table's values (from these particular columns), including headers
I tried to set up the rage as:

Please Login or Register  to view this content.

but returns only the headers

[Naveed Raza]

Hi

In place of #headers replace this #All and Try some thing like this

Please Login or Register  to view this content.

[boboivan]

Hi

In place of #headers replace this #All and Try some thing like this

Please Login or Register  to view this content.

Thanks!
Works like a charm.

[Naveed Raza]

Hi

Glad to help you

please don't forget to mark this thread as SOLVED and click on Add Reputation to say thanks