array sintax
i have recorded a macro. and that's exactly what i want to do, but need it to
be a little more versatile.
Sheets(" DB ").Select
Rows("1:6").Select
Selection.Copy
Sheets(Array("asdd", "Plan9", "Plan10", "Plan11", "Plan7")).Select
Sheets("asdd").Activate
Rows("1").Select
Selection.Insert Shift:=xlDown
i would like to select the arrey using the sheets number insted of the
"names"
something like:
Sheets(Array("1 : worksheet.count").Select
i thank in advance
|