I want to use the FillAcrossSheets method to copy a range of cells to multiple sheets. The example I have found looks like this:
x = Array("Sheet1", "Sheet5", "Sheet7")
Sheets(x).FillAcrossSheets _
Worksheets("Sheet1").Range("A1:C5")
But I want to do define "x" by using a range of sheet index numbers instead of a list of sheet names. (The sheet names are very long). I am VERY new to this so please be gentle.
Do I have to define "x" as an array? Is there a way to define "x" as 38-49 where 38-49 are the sheet Index numbers?
x = Array("Sheet1", "Sheet5", "Sheet7")
Sheets(x).FillAcrossSheets _
Worksheets("Sheet1").Range("A1:C5")
But I want to do define "x" by using a range of sheet index numbers instead of a list of sheet names. (The sheet names are very long). I am VERY new to this so please be gentle.
Do I have to define "x" as an array? Is there a way to define "x" as 38-49 where 38-49 are the sheet Index numbers?