I have the following range selected in an excel spreadsheet
how do i sort sel1 accodring to Column E Alphabetically Ascending?PHP Code:Dim sel1 As Excel.Range
key1 = "A" & intUpperSort
key2 = "A" & intUpperSort + intRowSortRange - 2
key3 = "E" & intUpperSort + intRowSortRange - 2
key4 = "E" & intUpperSort
sel1 = oSheet.Cells.Range(key1, key3)
thx
db




Reply With Quote