Need a VBA Code for select multiple sheets on excel

[ndiaye]

Hi, I am new user. And i need help.

I need a multiple selection VBA code for my work.

For example:

SheetX
SheetY
SheetZ
SheetA

I only need to select: SheetX and SheetZ. How should i write VBA Code for this?

I have nearly 450 sheets and will wrote the code for them.

Thanks a lot and have a good day to all from Istanbul, Turkey!

 

[Michael M]

This will select by Sheet name

Sub MM1()
 Sheets("Sheet X").Select
 Sheets("Sheet Z").Select (False)
End Sub

And this one by Sheet number

Sub MM2()
 Sheets(1).Select
 Sheets(3).Select (False)
End Sub

 

[ndiaye]

Hi again,

One of the excel sheet name is including "ş","ğ" etc.

What should i do? It brings the values as "?"

What am i gonna do? Btw thanks for first rep.

This will select by Sheet name

Sub MM1()
 Sheets("Sheet X").Select
 Sheets("Sheet Z").Select (False)
End Sub

And this one by Sheet number

Sub MM2()
 Sheets(1).Select
 Sheets(3).Select (False)
End Sub

 

[ndiaye]

Once again,

I tried with sheetname method and received an error - I wrote the problem the previouse time.

I tried the to select the sheet with their index names but it says

run time error 1004
select method of worksheet class failed

I searched it a little could not find smtg useful.

Hi again,

One of the excel sheet name is including "ş","ğ" etc.

What should i do? It brings the values as "?"

What am i gonna do? Btw thanks for first rep.

 

[ndiaye]

I Solved this myself.

The problem is there must be a hide'd sheets!

When i run it again - using the method sheet index - it worked!

Thanks for replier and the viewers and also me!

Once again,

I tried with sheetname method and received an error - I wrote the problem the previouse time.

I tried the to select the sheet with their index names but it says

run time error 1004
select method of worksheet class failed

I searched it a little could not find smtg useful.

 

[Michael M]

Ok, glad you got it sorted ...

 

[ndiaye]

Thanks man, cheers!

Ok, glad you got it sorted ...