I would like to create a macro to sort columns A:F in a range of A3:F400 in ascending order.( "A" in ascending order then "B"in ascending order then "C" etc.) When I try the Excel sort it only does 3 columns. ( when record the sort as a Macro and try to add more columns it doesn't work). At this point I either need to by hand reselect the range to exclude the already sorted cells or figure out a macro to run. I would appreciate any help as I am sure you have seen this problem before. Also, I have found some great stuff in your site, but searching through the maze of questions for this answer has proved very frustrating. Thanks again.
This message was edited by Earbrows on 2002-04-19 10:39
This message was edited by Earbrows on 2002-04-19 10:39