S
Stephan Otto
Hello everybody,
I would like to select some sheets and copy them to a different workbook. If
I use the following it works fine:
....
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Copy
....
But the problem is, that I must have the array in a different way. The
sheets, that must be copied, are always different. I need something like:
Dim mysheets As ???
....
mysheets(0) = "Sheet1"
mysheets(1) = "Sheet2"
mysheets(2) = "Sheet3"
....
Sheets(mysheets).Select
Sheets(mysheets).Copy
....
But I don't get it. What kind of variable must I use? Variant doesn't work.
Neither does Dim mysheets() As String.
Thanks in advance,
Stephan
I would like to select some sheets and copy them to a different workbook. If
I use the following it works fine:
....
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Copy
....
But the problem is, that I must have the array in a different way. The
sheets, that must be copied, are always different. I need something like:
Dim mysheets As ???
....
mysheets(0) = "Sheet1"
mysheets(1) = "Sheet2"
mysheets(2) = "Sheet3"
....
Sheets(mysheets).Select
Sheets(mysheets).Copy
....
But I don't get it. What kind of variable must I use? Variant doesn't work.
Neither does Dim mysheets() As String.
Thanks in advance,
Stephan