| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing specific items in a range
Just found this forum but also here I'm not able to find a answer to am question. Data in my sheet is arranged such that sometimes there's 1 or mor spaces in between pieces of data. I thus create ranges usin .SpecialCells(xlConstants) which works wonderfully. My problem now is that the only way to run through the range to fin something is to use the For Each option. I can't access e.g. the 5t piece of data in such a range other then using For Each until I get t the 5th item. Does anyone know of a way to directly access items in ranges creat using .SpecialCells(xlConstants)? Thanks and best regards, Leo -- droopy928g ----------------------------------------------------------------------- droopy928gt's Profile: http://www.excelforum.com/member.php...fo&userid=3023 View this thread: http://www.excelforum.com/showthread.php?threadid=49906 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =COUNTIF(range, select items highlighted with specific color) | Excel Worksheet Functions | |||
| Counting items with a specific quanitifier in a date range | Excel Worksheet Functions | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| How do I copy specific items to another worksheet? | Excel Worksheet Functions | |||
| Accessing/Clearing range in hidden workbook | Excel Programming | |||
Threaded Mode
