Please explain this code vba about sort number

[Hero123]

Hello Everyone
I am studying the VBA and looking for this code about sort number .I think so much but did not understand .maybe i am stupid!
.............
Dim i As Integer, j As Integer, temp As Integer, rng As Range
Set rng = Range("A1").CurrentRegion
For i = 1 To rng.Count
For j = i + 1 To rng.Count
If rng.Cells(j) < rng.Cells(i) Then
'swap numbers
temp = rng.Cells(i)
rng.Cells(i) = rng.Cells(j)
rng.Cells(j) = temp
End If
..........
i did understand this code : rng.cells(j)=temp .
why not use temp=rnd.cell(j) and what ' different ?
Please explain
Thanks.

 

[wideboydixon]

This is an implementation of a Bubble Sort (see https://en.wikipedia.org/wiki/Bubble_sort)

When you need to swap numbers, say in A3 and A4, you have to do the following:

- Store the value of A3 in a variable (temp in this case)
- Replace A3 with the value in A4
- Replace the value in A4 with the stored value (from temp)

WBD

 

[wideboydixon]

You can see a visual representation of this sort here:

https://visualgo.net/bn/sorting

WBD

 

[Hero123]

Thank you so much