I have a VB.NET application which writes into an excel sheet from SQL database. Additionally, I also format this sheet. Apart from other things, I am suppose to sort the data in the first column. The VB.NET code for this function is completly different from the Macro generated. I obtained this code from internet, but for some reason, my data still does not get sorted. Pls help !
Pls note that the first 2 rows of the Excel sheet are headers and are kept 'Frozen'.
The first column, the column I want the data to be sorted is all numeric and I want the data to be sorted in ascending order.