| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through Non contiguous cells in a row
Hello,
I want to loop accross each cell in a row oa a non contiguous range, something like for I=1 to NumberOfRows for J=1 to NumberOfCols msgbox MyRange.Rows(I).cells(I,J).value next next The problem is that the J seems to refer to the contiguous range starting with first column of the range Any help Avi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non-contiguous cells | Excel Discussion (Misc queries) | |||
| Copy and Paste LAST ROW of data: non-contiguous Row, contiguous Column | Excel Programming | |||
| Looping over non-contiguous column selection | Excel Programming | |||
| counting cells that are 0 in a range of non-contiguous cells | Excel Worksheet Functions | |||
| How do I count non-contiguous cells? | Excel Worksheet Functions | |||
Threaded Mode
