Okay, I am 50% toward having this figured out, but there are a couple of concepts that are new to me here and it is throwing me for a loop.
I am reading an Excel file into VB.NET. There are 4 columns containing dollar figures of varying amounts. Here is what I need to do is identify the columns with the highest $ figure, the next highest, etc. and mark them so that .NET can identify them (e.g. col3 is highest so rank1 variable is "col3" and so on).
So I am dealing with Excel Ojects which is new to me and sorting which is new to me. If it helps, here is how I am reading in the Excel file:
xlsWorkBook = xlsApp.Workbooks.Open(folders(f).ToString & "\" & fileInFolder.ToString) xlsWorkSheet = xlsWorkBook.Worksheets("Sheet1") Dim ColumnNumber As Integer = xlsWorkSheet.Cells(1, StartColumn).Column For r = 6 To xlsWorkSheet.Range(StartColumn & "65536").End(xlUp).Row 'Need sorting here Next