Selecting worksheets in a workbook based on criteria

**josnah** · 01-13-2008, 01:32 AM

hi,

how can i select worksheets in a workbook based on a certain criteria.

For example, I have worksheets that start with "18" together with other worksheets.
1811, 1812, 1813....1899, Data, PivotTable, etc....

how can I select only the worksheets starting with "18" using a macro?

these worksheets are generated by showing all pages using a pivottable. hence the using the Sheets(Array(x,y,z...)).Select will not work.
as its difficult to determine the exact no. of sheets starting with "18" everytime the macro is run.

any help is greatly appreciated!

josnah

**royUK** · 01-13-2008, 03:40 AM

Why do you need to Select the sheets, it is usually unnecessary in VBA?

This code will select all sheets starting with 18

Please Login or Register  to view this content.

**VBA Noob** · 01-13-2008, 03:47 AM

or maybe

Please Login or Register  to view this content.

VBA Noob

**josnah** · 01-13-2008, 07:27 AM

thanks both for your help...

i'll need to select the sheets first and then run another macro to format the sheets...
i may not be technically correct by doing this.
i'm not sure if i can not select the sheets first but run the other macro on sheets beginning with "18"

**VBA Noob** · 01-13-2008, 07:41 AM

You can loop through the sheets something like this.

Puts the Sheet name in Range A1 and makes it bold

Please Login or Register  to view this content.

VBA Noob

**josnah** · 01-13-2008, 10:47 AM

thanks alot VBA Noob!

That works just great now

and yes faster too...

Selecting worksheets in a workbook based on criteria

LinkBack

Thread Tools

Rate This Thread

Display

Selecting worksheets in a workbook based on criteria

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions