Bahester
10-17-2010, 07:01 PM
I'm fairly new to programming and VBA overall but I basically have to make a sorting algorithm that can sort a bunch of random numbers from lowest to highest. I know it's a lot easier to do this using an array or the .sort function but I'm required to use 2 loops so that at the end I can "animate" and watch the sorting actually happen.
My brain is fried from trying to figure this out. All I've got so far is:
a = Range("b2").Offset(1, 0).Value
With Worksheets("linesort")
countCell = Range("SortedLine").Count
End With
For i = 1 To countCell - 1
lowest = a
For j = 1 To countCell - 1
Any help would be greatly appreciated :dunno
My brain is fried from trying to figure this out. All I've got so far is:
a = Range("b2").Offset(1, 0).Value
With Worksheets("linesort")
countCell = Range("SortedLine").Count
End With
For i = 1 To countCell - 1
lowest = a
For j = 1 To countCell - 1
Any help would be greatly appreciated :dunno