Friday 15 July 2011

sorting - Independently sort multiple columns in excel -


I am trying to sort lists of Z from A to large numbers. But if I select the column A, T wants to re-organize all other columns. I need all these lists so that individually as described in alphabetical order. I know that it is possible to do one after the other but I have 278 columns. Is there no empty cell in any column data?

So the following is a different approach that does not consider the maximum for the number of rows.

  Sub-Sortindiserjr () dim dimension in the form of dim rngFirstRow range, such as range dim range worksheet application. = Incorrect set ws = ActiveSheet set rngFirstRow = ws.Range ("A1: JR1") for each rng with ws.Sort in rngFirstRow. .SortFields.Clear .SortFields.Add Key: = rng, Command: = xlAscending 'Assume there are no empty cells .. .set waze.Range (rng, rng.End (xlDown)) .Header = xlYes. MatchCase = False. Finish with the next RNG application. ScreenUpdating = True End Sub   

There is nothing wrong with the code of user 1281385; As I said, this is just an option.

Added If there are some spaces, modify the above code to use .set ws.Range (rng, rng range ("A1000 "). End (XLEEP)) , whatever you expected, will exceed the maximum number of more than 1000 data-rows.

No comments:

Post a Comment