microsoft.public.excel - Microsoft Office Excel
I've used this code for awhile, & it HAD worked. But NOT now. Range("DTop").Select Selection.Sort Key1:=Range("AJ65"), Order1:=xlDescending, Header:=xlGuess _ , OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Is there another way to ensure a Sort?? TIA - Bob
I am Subtotaling in Excel 2003 and the results are not even close anyone having any issues besides me. My test file is only 35 lines long and 6 columns wide.
I have a list with name, company, address, city.....etc. When I click on data sort (i do check the box to include column headings) and do a sort by say address, it will sometimes exclude a column such as name from the sort. It does not always do this. Is this a glitch? Do I need to highlight the entire list before I sort? Also, sometimes if I just use the Ascending or Descending icon rather that going to data, sort it will only sort that column and not the rest of the data with it.
In a table I wish to insert data to a certian column and than to have the respected row sorted automatically accordingly.Meaning the whole table will be sorted 1 column but automatically as I insert the data to the column. Thanks