How to calculate median of unsorted values

Question

Hello, is there a way to use Excel or VBA to determine the median of a row of unsorted values? Or perhaps there is a technique to organise values in a row using VBA.

Answer 1

In vba code:

Dim r As Range
Dim result
'Set r = Range("C:C") 'Column C
Set r = Range("3:3") 'Row 3
result = Application.WorksheetFunction.Median(r)