| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to reverse data in an Array
Dim c() As Integer
Dim ends(20) As Integer For d = Sheet11.Cells(18, 14).Value - 1 To 0 Step -1 ends(d) = Range("A50000").End(xlUp).Row c() = ends() Next d 'end stud loop ReDim Preserve c(Sheet11.Cells(18, 14).Value - 1) The data in the table is backwards. I assume due to the step -1? Is there a VBA command to reverse the data in c() ? Ex. from 1,2,3...to 3,2,1... Suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reverse a function to return the array? | Excel Worksheet Functions | |||
| search an array in reverse (bottom to top) order | Excel Discussion (Misc queries) | |||
| reverse data | Excel Discussion (Misc queries) | |||
| how to reverse a range/array? | Excel Worksheet Functions | |||
| DATA VALIDATION IN REVERSE | Excel Discussion (Misc queries) | |||
![Kevin O'Neill[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
