How to sort a column (Price) from an excel file?

I’m really lost on how to sort a single column in my excel file to ascending and print the LOWEST price out through a message box

… I tried the “Sort data table” but didnt work. I couldnt use “Sort data” because i have no “Table name” in my excel file so that is out of the question (probably).

Any advice?

@Ibra Follow below link

That query the other guy replied with doesnt work.

Maybe sort the column in excel before reading it ?
Or read range, sort, write in excel?


This worked for me…
(The first assign in the To its written “ebayData.DefaultView.Sort”