Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with sort
I'm using excel 2003. I want to sort data formatted as text in a column.
Most of the cells in the column are blank. I am using the following code: With Sheets("MarginAnalysis") ..Cells.Sort Key1:=.Range("b225:B270"), _ Order1:=xlAscending, Header:=xlNo, _ MatchCase:=False, Orientation:=xlTopToBottom End With The error I get is "This operation requires the merged cells to be identically sized. " There are no merged cells anywhere in the range selected. When I go to the worksheet "marginanalysis" after the program stops the range b225:b282 is highlighted.?? I'm lost and any help would be appreciated. Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort by column problems | Excel Worksheet Functions | |||
Sort problems | Excel Discussion (Misc queries) | |||
Custom Sort Problems | Excel Programming | |||
Excel Sort Problems | Excel Programming | |||
Date sort problems | Excel Discussion (Misc queries) |