Thread: array sintax
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paulo Paulo is offline
external usenet poster
 
Posts: 47
Default 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