Sheets Array

[Dave]

The following line of code works:

Sheets(Array(1, 2, 3)).Select
however, when I try and do this programmatically
eg:

mysheets ="1, 2, 3"
Sheets(Array(mysheets)).Select
It fails - can anyone point out what I am missing.

Many thanks

 

[papou]

Hello Dave
mysheets = Array("1", "2","3")
Sheets(mysheets).Select

HTH
Cordially
Pascal

 

[Dave]

many thanks!

-----Original Message-----
Hello Dave
mysheets = Array("1", "2","3")
Sheets(mysheets).Select

HTH
Cordially
Pascal

"Dave" <[email protected]> a écrit dans le message de



.