Select several work sheets in the same book with PP in tab name ...

[james 35]

HI guys I have a pretty heafty workbook wich is nearly done bar optimising and sorting options..
Many sheets many different names ! but the ones I want to select as a range to be sorted by another sub that is called all start with PP as the tab name!
*
I thought the below code would help. I've attempted to modify to no avail :-? any advice guys ??
*
Thanks
*

Please Login or Register  to view this content.

*
Code to be called to sort selected range of sheets this works well when manually selecting a range of sheets !!!
*

Please Login or Register  to view this content.

*
Thanks again guys

[arlu1201]

You can try

Please Login or Register  to view this content.

[james 35]

Hey Arlu

and sorry for late reply, The nippers are on Half term break this week so I'm off work until tomorrow..

I have tried your suggestion though with open office as thats all thats installed on My laptop.. :-/

I'm a bit lost as to which code I need to insert though?

thanks again !

James

You can try

Please Login or Register  to view this content.

[james 35]

Hi9 again Arlu

Ive added the codes together as below However the Sub never ends lol

Any Idea's??

Thanks

Please Login or Register  to view this content.

Hey Arlu

and sorry for late reply, The nippers are on Half term break this week so I'm off work until tomorrow..

I have tried your suggestion though with open office as thats all thats installed on My laptop.. :-/

I'm a bit lost as to which code I need to insert though?

thanks again !

James

[james 35]

Arlu

I think the problem is that it only select one sheet witht he "PP*" Prefix where as I need to select all of them as an array ie. Sheets(Array("PP*")) or something like that ??

Thanks

James

[arlu1201]

How did you manage to get this solved?

It will be good if you share the solution, for the benefit of other users.