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

shts(1).Select

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.

**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.