Store sheets into array via loop to copy to new book

Hi all

I suck with arrays....My scenario as follows:
I have 7 checkboxes on a frame on a user form
I am wanting to loop through checkboxes populate sheets based on True value of cb into array and copy those sheets only to newbook and save in selected path...
This is what i have so far...

Please Login or Register  to view this content.

K sorted...Now as the sheets contain Tables another problem arises...

Please Login or Register  to view this content.

K, this seems to work...Thanks All

Please Login or Register  to view this content.

Talking to yourself again @sintek

@kev...Yep, method in my madness...Keeps me sane lol

Alrighty then, so this worked last night but now....no more. have uploaded a sample. Perhaps someone can assist...

Edit...so for those of you that have just tuned in. What i am trying to achieve is the following:
Dependent on the check box values, I want to store those sheets into an array and then copy and save to a selected path.
Each sheet contains a Table though...
Edit2...
Code runs on a normal range, but not with tables....

Please Login or Register  to view this content.

Gees guys...thanks so much for all the responses...I couldn't keep up lol....
This crappy workaround does the job...Will still like to figure out a better solution.

Please Login or Register  to view this content.

Hi,

Not much point in the array there- you might as well copy each sheet in your first loop.

Nice one xlnitwit...Thanks

Please Login or Register  to view this content.

Just one last thing- this line

Please Login or Register  to view this content.

will be true not only for checkboxes but also for optionbuttons and togglebuttons. It is safer to use TypeName if you only want to process checkboxes

Please Login or Register  to view this content.

Coolio...Thanks...so i am assuming there is no workaround to original problem...

This is the workaround. You just can't copy multiple sheets at once if any of them contain a Table, whether you do it manually or via code. You could alternatively convert the tables to ranges, copy the sheets then reinstate the tables, but that would involve considerably more work.

Thought this was to good to be true...
https://blogs.office.com/en-us/2009/...list-or-table/

I guess I stand corrected- I had never seen that before. It does work with your sample workbook, for me at least- after changing the sheet names put into the array.

Please upload the code correction that allows it to work.

All that I did was to add the relevant sheet name in the Tag property of each checkbox and then amend the code thus

Please Login or Register  to view this content.

I sincerely think that you have solved the initial problem posted...What am I missing xlnitwit...

Please Login or Register  to view this content.

Nothing- it worked for me.

just my luck then....Untitled-1.gif

Can you post the revised workbook? I can only test in 2010 currently but do have 2007 at home somewhere.

Here you go...thanks for your time.

That definitely works in 2010. I'll try to test in 2007 later.