Does anyone know what the code would be to do a secondary sort when exporting to Excel. I want it to first sort by column A and then by column B.
Set xlSheet = xlApp.Workbooks(1).Worksheets("Sheet1")
Set range1 = xlsheet.Range("A2: B2000")
Call range1.Sort(xlsheet.Columns("A"), , , , , , , 1)