I am trying to write a function where vba will find a column say "abc" and then sort the rows below it using the values in the selected column in ascending order. I am so far stuck on the first part, but here is what I have:


Sub SelectSort()

Dim rng1 As Range
Set rng1 = Range(Range("A1:Z1").Find("abc"))
MsgBox rng1

End Sub