Sheets Array

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
Hello Dave
mysheets = Array("1", "2","3")
Sheets(mysheets).Select

HTH
Cordially
Pascal
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Playing back a Pivot Table macros 2
VBA: selecting sheets and copy them to a workbook 5
Code to copy worksheet 5
ERROR 400 on identical codes different range 8
Array code only works on selected sheet 14
Selecting worksheets 5
Array to Multiple Arrays 3
How to make it work for "WHOLE" workbook 4

Back
Top