| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to "return" the array element number in VBA
2003
Challenge: For Each myCell in myRange ..... ..... 'Would like to be able to move to the next myCell in a (non-contiguous) 'myRange if the current myCell.Value = 0. I do not know how to return 'the current myCell array element number AND to increment to the next 'non-zero "0" myCell.value ..... ....... Next myCell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| row number question in an array | Excel Worksheet Functions | |||
| How do I set up a 6 day work week in Excel? | Excel Worksheet Functions | |||
| number anagram | Excel Worksheet Functions | |||
| Permutations of an array element < to a value | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Threaded Mode
