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