VBA Select All But Four Sheets In Workbook

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

From a number of threads I've found, I've put together the following script to select all sheets within my workbook, except for four.

Please Login or Register  to view this content.

The script runs, but only selects the last, out of about twenty of the sheets, and I'm a little unsure why.

I just wondered whether someone may be able to look at this please and let me know where I've gone wrong.

Many thanks and kind regards

[HaHoBe]

Hi, hobbiton73,

any Select you perform will only have one sheet to refer to, the last sheet you found. Maybe try it like this building an array and using that for selecting (although any Selection should be useless as action may be done withour this):

Please Login or Register  to view this content.

Ciao,
Holger

[hobbiton73]

Hi @HaHoBe, thank you very much for taking the time to reply to my post and for the solution, which perfectly, and I was particularly interested about your comment on how the 'Select' function works.

Because I'm relatively new to VB, may I ask if you could possibly insert some comments into the code, so I can learn from this.

Many thanks and kind regards

[HaHoBe]

Hi, hobbiton73,

I´m a bit out of time by now - so it´s sort of "Typos To Go":

Please Login or Register  to view this content.

Ciao,
Holger

[hobbiton73]

Hi @HaHoBe, that's absolutely no problem at all, thank you very much for doing this.

Kind Regards and all the best.