Code no longer works as expected

[vbapadawan]

I got this code from AlphaFrog which worked great, however, now it doesn't and I am not sure why.
I have done a lot to the project since implementing this code and am not sure if this is the cause?

The code allows the user to select various columns (not nessariliy in sequence) in the active spreadsheet from Listbox2 and export the columns to a new workbook.

What happens now is that irrelevant of what column heading is selected in the listbox, the code only seems to look at how many items are in the list and returns the number of columns in sequence from 1 to i. I think there is something amiss with the Union?

Please Login or Register  to view this content.

list box code

Please Login or Register  to view this content.

[AlphaFrog]

which worked great, however, now it doesn't

Too vague.

[vbapadawan]

Too vague.

Sorry AlphaFrog, I added some detail, The problem I am having is that it doesn't matter what I select in Listbox2, it seems to only count how many entries have been moved form Listbox1 to Listbox2, selects the number of columns in the count from left to right and exports that I'm not sure why it no longer works; I didn't change the activesheet except I added some columns. I cannot include data example as it is sensitive.

[AlphaFrog]

Can you provide an example workbook?

[vbapadawan]

Can you provide an example workbook?

i have attached an example...

[1aaaaaaaaaaaaaaa]

I modified your code, by adding a nested for loop that checks the list items against the column headers, and then add the matched column header range into the MyRange union.

Please Login or Register  to view this content.

[vbapadawan]

Thats Perfect, job Done. Thank you Poizhan

I modified your code, by adding a nested for loop that checks the list items against the column headers, and then add the matched column header range into the MyRange union.

Please Login or Register  to view this content.

[1aaaaaaaaaaaaaaa]

Youre welcome

Thats Perfect, job Done. Thank you Poizhan