Function to sort data in Excel dynamically

Hi

Is there anybody who knows where I can find a function which will sort a range dynamically? Right now I'm using the rank-function and vlookup to do this, but I would love to have a specific function (VBA) which can do it.

Do anybody know if somebody have made this? I have found this one, but I would prefer if it wasn't arrays.

Regards
Herby

What do you mean? You can click the sort button on the tool bar, and that will sort alphabetically.

Yes. But not dynamically. If I change data, the sorted range does not update automatically.

I need to be able to add a function like "sortfunction("$A$1:$A$10")" in "C1:C10" where "C1:C10" will be the sorted data from "A1:A10".

You might try something like this:

Sub SortA4C()
    Dim i As Long, j As Long, v As Variant, vArray() As Variant
    'Copy Range to Array
    vArray = Range("$A$1:$A$10")
    'Bubble Sort Array
    For i = LBound(vArray) To UBound(vArray) - 1
        For j = i + 1 To UBound(vArray)
            If vArray(i, 1) > vArray(j, 1) Then
                v = vArray(j, 1)
                vArray(j, 1) = vArray(i, 1)
                vArray(i, 1) = v
            End If
        Next j
    Next i
    'Copy Array to Range
    Range("$C$1:$C$10") = vArray
End Sub