| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple array macro works on one sheet only
This in a standard module only works on the sheet from which it is called. Should it not do all four sheets run from any sheet? Howard Sub Plain_Copy() Dim MyArr As Variant Dim i As Long MyArr = Array("Sheet1", "Sheet2", "Sheet3", "Sheet4") For i = LBound(MyArr) To UBound(MyArr) Sheets(MyArr(i)).Rows("2:2").Copy Rows("4:4") Next 'i End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array code only works on selected sheet | Excel Programming | |||
| Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
| Simple Macro Works on PC But Not Mac--Help! | Excel Discussion (Misc queries) | |||
| simple copy column works but ERROR! | Excel Programming | |||
| Simple Macro, works in Excel 2002, 2003 but won't work in 2000 | Excel Programming | |||
Threaded Mode
