Put starting with "X" or "3" sheet into array

[kitsontam]

Hi all, may i have your help. details as following.

Basically, when the sheet number change, i manually change the sheet array at vba. any good way to put the sheet which name starting with "X" or "3"

Dim WshtNames As Variant
WshtNames = Array("X310361", "X310377", "X310379", "X310400", "310531", "310539", "X310561", "X310579", "X310605", "310610", "310645", "310646", "310647", "310653", "X310660", "X310662", "310665")

[Richard Buttrey]

Maybe a block of code to cycle through the sheet names that start with X or 3 and when found add them to the array.

You could perhaps count them first and use that count to Redim the array name and then loop through the sheet names.

[AlphaFrog]

What are you doing with the array?

[kitsontam]

would you provide me example, so that i can test?

[Richard Buttrey]

Here's one way

If you wanted to avoid the two loops you could use the Redim Preserve option in the first loop and remove the second

Please Login or Register  to view this content.

[kitsontam]

Hi Richards, i put your code to new excel and start the macro but nothing show.