| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with cells Array
For Each sht In Sheets(Array("NSB West 2008", "NSB West 2009", "NSB East
2008", "NSB East 2009", "NSB Manhattan")) I am trying to use the line of code below, just like the one above but I am getting a Method 'Range' of object '_Global' failed. Any ideas? Thanks. For Each c In Range(Array("D8", "F8", "H8", "J8", "L8")).Cells |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
| adding cells within an array | Excel Worksheet Functions | |||
| Can a UDF be used on an array of cells? | Excel Worksheet Functions | |||
| How do I sum an array of cells, even if some of them are #N/A | Excel Discussion (Misc queries) | |||
Threaded Mode
