Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all
Is it possible to decrease an array? EG with the following Code. If I wanted to be left with the 3 highest number in that array. I could add them to a Collection and remove them based on a logic comparison, as 1 option. What are the other options, and are there better watys of doing this? Sub TestArrays() Dim iDiceRoll(5) As Integer Dim i As Integer For i = 0 To 5 iDiceRoll(i) = ((6 * Rnd) + 1) Next i End Sub Thanks in advance Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
decrease integers to zero | Excel Worksheet Functions | |||
decrease formula bar | Excel Discussion (Misc queries) | |||
How do I decrease the gap width of the Up/down bar? | Excel Discussion (Misc queries) | |||
% of increase or decrease | Excel Discussion (Misc queries) | |||
Automatic % decrease | Excel Discussion (Misc queries) |