Export selected column to new workbook

[Manish84]

Hi Friends,

I am trying to copy selected columns to a new workbook.

- Copy selected columns in ListBox1 to a new workbook
- Row containing data will keep on changing (can increase or decrease), I mean to say that Range("B4:P25") is not fixed. So I need to keep it dynamic
- For column selection i am trying to use ActiveX ListBox (so that multiple selection is enable), if you want you can use some other method also

Here is the attached sample file Delete Selected Columns.xlsm

Thanks & Regards,
Manish

[xlbiznes]

try this code ,

Please Login or Register  to view this content.

[xlbiznes]

Improvising the code a bit, to copy only the used cells change this line of code

from :

Please Login or Register  to view this content.

to :

Please Login or Register  to view this content.

[Manish84]

Thanks xlbiznes,

Little bit of problem is there with the code.
It is not selection Col 1. In i only select Col 1 then i am getting error in the below line

Please Login or Register  to view this content.

And if along with other columns i select Col 1 also then it does not select Col 1

[xlbiznes]

oops, here you go.

Please Login or Register  to view this content.

let me know if this is fine.

[Manish84]

Yes xlbiznes, its working fine. and now i also figured out what the problem was.

Thanks a lot you made my life easy.

Regards,
Manish

[xlbiznes]

you are welcome,

Please mark this thread as solved, if you are satisfied with the solution provided.