Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Data/Sort/ one can choose upto 3 columns to sort values. I need the
same functionality to be achieved by coding. Reason, when I use the menu Data/Sort, I get an error message stating that ' "This Operation requires the merged cells to be identically sized." Since the columns can't be of same size because of macro used in the last cell to wrap the text, coding is the way to achieve the object. Can one write the code for this. Column B(general) , column C(text) and Column D(text) &E(numeric). The sort has start at col B, then C, D and E all ascending. It should change the row data which goes upto column Z. Thanks, murthy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to compare/sort values in two columns of two worksheets? | Excel Discussion (Misc queries) | |||
Formula and values stay with row/cell after sort | Excel Worksheet Functions | |||
How do I match identical values in 2 columns and then sort? | Excel Discussion (Misc queries) | |||
sort columns within a merged cell header | Excel Discussion (Misc queries) | |||
Sort cell values | Excel Programming |