| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating small "recordset" or sorting a numeric 1-dim array
Hi Everyone,
I am attempting to sort a small one-dimensional array of integers (about 10 or 15 total) that are currently in no particular order into a greatest--least. Is there a way that I can do this in VBA? Or, is it possible to create a recordset in Excel from my array, which I can then sort? The array is variable, and will often change, so the recordset (and the array) would be a temporary solution, created & deleted each time the macro runs. Thanks, Anthony |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a "date selector box" or "pull down box" in a cell | Excel Worksheet Functions | |||
| "Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
| Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
| If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
| "Small" Multi-Dimensional Array Slow Writing To Cell | Excel Programming | |||
Linear Mode
