Sheets Array
 

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

Sheets Array
 

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

HTH
Cordially
Pascal

"Dave" a écrit dans le message de
...
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

Sheets Array
 

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

HTH
Cordially
Pascal

"Dave" a écrit dans
le message de
...
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


.