Nosstech
09-03-2008, 07:22 AM
I am trying to sort column A. Excel will sort, but starts at A1 instead of A2. Because of that, my heading is being moved down to the bottom of the spreadsheet. Please help...
Cells.Sort Key1:=Range("A2:A2000")
totalrows = ActiveSheet.UsedRange.Rows.count
Cells.Sort Key1:=Range("A2:A2000")
totalrows = ActiveSheet.UsedRange.Rows.count