Hey,

I'm using the following code to search an excel document for the highest value within a range. What I need is to get the column letter that corresponds with that MAX value.

Code:
xlTemp.Workbooks.Open("http://somesite/" & String.Format("{0:yyyyMMdd}", DateTime.Today.AddDays(7)) & ".csv")
xlTemp.Visible = False
'Search the specific range and find the MAX value
xlRange = xlTemp.Range("A15:X17")
xlMax = xlTemp.WorksheetFunction.Max(xlRange)
peakArrayList.Add(xlMax)
xlTemp.Workbooks.Close()
Thanks,
Sean