Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
first time array help
trying to use array to define 9 sheets tabs for sheets Nbr 1-9
cannot get pass following. Dim ws As Worksheets For Each ws In ThisWorkbook.Worksheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5", "sheet6", "sheet7", "sheet8", "sheet9")) for each yellows out code here for print area and nbr copies is it to many sheets does array have limits build these sheets then want to print out of all at same time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time array | New Users to Excel | |||
Time array | Excel Worksheet Functions | |||
Time array | Excel Programming | |||
FILL ARRAY ONE ROW AT A TIME | Excel Programming | |||
How to activate array formulas in a range of cells all at the same time? | Excel Programming |