Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Bubble Sort Function
I have an 1D array that I have filled within a For Next Loop. There
are roughly 60,000 values within the array. Upon filling the array, I want to sort the data within the array. The array is called CalculationArray. When I call the bubble sort function, it fails within the function and gives a type mismatch error. (It fails on "For i = 1 To List - 1"). Why is this so? 'Call Sort Function and Sort Bidding Array BubbleSort CalculationArray Function BubbleSort(List As Variant) ' Sorts an array using bubble sort algorithm Dim First As Long, Last As Long Dim i As Long, j As Long Dim Temp As Long First = LBound(List) Last = UBound(List) For i = 1 To List - 1 'THIS IS WHERE IT FAILS For j = i + 1 To List If List(i) List(j) Then Temp = List(j) List(j) = List(i) List(i) = Temp End If Next j Next i End Function Thanks TS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 'bubble' chart where colors are used instead of bubble size | Charts and Charting in Excel | |||
How can I change the color of negative bubble in bubble chart | Charts and Charting in Excel | |||
How can I change the color of negative bubble in bubble chart | Charts and Charting in Excel | |||
ho to change in the bubble chart the bubble position and size | Charts and Charting in Excel | |||
How do I move a hidden bubble to the front in a bubble chart in E. | Excel Discussion (Misc queries) |