Select Multiple Sheets based on List

**roasty_1** · 10-24-2008, 06:28 AM

Hi All

File attached to show problem

How do I select all the sheets that are Marked Y in column B when the button is clicked?

Thanks

Roasty

**Stuie** · 10-24-2008, 06:42 AM

Hi roasty_1,

I have attached a workbook and i have coded the button to check each one and then add that worksheet to a array of worksheets.

to access the worksheet you can use this code

Please Login or Register  to view this content.

change the 1 to the index you need and the Select the method you want to call.

anything else let me know

**roasty_1** · 10-24-2008, 06:50 AM

thanks

sorry but the button does not do anything.....

no sheets are selected when the code has run?

thanks

**Stuie** · 10-24-2008, 07:00 AM

oh right sorry i have loaded them into a array so you can access them sheets, sorry i didnt realise that you wanted them selected. i will have a look to see if i can work that one out

**roasty_1** · 10-24-2008, 07:24 AM

ok
cheers

**Stuie** · 10-24-2008, 07:57 AM

sorry roasty_1, i cant seem to get it to work no matter what i try.

does anybody else know how to do this as i am now interested.

**antoka05** · 10-24-2008, 08:00 AM

Try attached file.

Regards,
Antonio

**Andy Pope** · 10-24-2008, 08:08 AM

There are a couple of ways of selecting the sheets.
Either using the Replace argument or by building an array of sheetnames.

Please Login or Register  to view this content.

**roasty_1** · 10-24-2008, 09:12 AM

Thanks Antonio

Works well, only it crashes Excel if any of the cells are left blank, not an issue though, can work round that.

thanks for your help.

**roasty_1** · 10-24-2008, 09:13 AM

Hi Andy

thanks for your help, couldnt get your code to work unfortunetly, thanks anyway.

**Andy Pope** · 10-24-2008, 09:21 AM

In what way did it not work?

raised an error
No selection of sheets

**roasty_1** · 10-24-2008, 09:29 AM

weird, it works now, before I was getting an Object error

Now works fine

Thanks!!

**miztify** · 01-21-2014, 02:46 PM

I'm confused where is the macro, VBA for the select sheets, its that the one for the sheet downloaded above?

**miztify** · 01-21-2014, 05:30 PM

I cannot get this to work, errored out on last line of code, Sheets(mySheets).Select?

**arlu1201** · 01-22-2014, 01:36 AM

miztify,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.