| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorted range into collection
Hi everyone,
I'm working with excel 2003 and I'm developing a custom interface to automatize some operations. I'm using the MS office VB editor. I can't use .net framework. I need to: - take the values contained in an excel column - sort values alphabetically - remove duplicate values - put the values in a collection. I need to do everything "on the code side", cell values on the sheet cannot be modified. The requisite of the collection is not mandatory, any similar object would be useful. I did many test but none of them works. Thanks in advance to everybody -- Nobody expects the Spanish Inquisition! Our chief weapon is surprise...surprise and fear...fear and surprise.... Our two weapons are fear and surprise... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First Value in Sorted Column is Not Sorted Properly | Excel Discussion (Misc queries) | |||
| Not sorted union range. | Excel Programming | |||
| Link to a named range in another worksheet that is sorted frequent | Excel Worksheet Functions | |||
| Insert rows into a sorted range | Excel Programming | |||
| Range collection | Excel Programming | |||
Threaded Mode
