Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort doesn't recognize current region
xl03/XP
The worksheet's rows are contiguous (1-8,724). When I attempt to sort, it selects the cells starting in row 5693. It is the same effect as if there were a gap and the active cell were in the lower portion of the sheet. If I copy all cells to a new sheet - all is well. If I copy the sheet ("Move/Copy") it fails on the new sheet. If I insert rows and select a cell in the upper region the sort command still selects the bottom region. There aren't any hidden rows etc. Using VBA the CurrentRegion is correct as is the UsedRange. As noted I can get around it by copying the cells to a new sheet, but it's got me "bugged". Any hints? -- Regards Rob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort doesn't recognize current region
Rob,
Sounds like your sheet has become corrupted. Bite the bullet and re-make the sheet starting from scratch. HTH, Bernie MS Excel MVP "RobWN" wrote in message ... xl03/XP The worksheet's rows are contiguous (1-8,724). When I attempt to sort, it selects the cells starting in row 5693. It is the same effect as if there were a gap and the active cell were in the lower portion of the sheet. If I copy all cells to a new sheet - all is well. If I copy the sheet ("Move/Copy") it fails on the new sheet. If I insert rows and select a cell in the upper region the sort command still selects the bottom region. There aren't any hidden rows etc. Using VBA the CurrentRegion is correct as is the UsedRange. As noted I can get around it by copying the cells to a new sheet, but it's got me "bugged". Any hints? -- Regards Rob |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort doesn't recognize current region
Thanks Bernie;
That's what I figured. No problem re-creating sheet - just copy all cells and paste. I was just wondering if there was something obvious I wasn't seeing - 1st time I've had that happen. Thanks again. -- Regards Rob "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Rob, Sounds like your sheet has become corrupted. Bite the bullet and re-make the sheet starting from scratch. HTH, Bernie MS Excel MVP "RobWN" wrote in message ... xl03/XP The worksheet's rows are contiguous (1-8,724). When I attempt to sort, it selects the cells starting in row 5693. It is the same effect as if there were a gap and the active cell were in the lower portion of the sheet. If I copy all cells to a new sheet - all is well. If I copy the sheet ("Move/Copy") it fails on the new sheet. If I insert rows and select a cell in the upper region the sort command still selects the bottom region. There aren't any hidden rows etc. Using VBA the CurrentRegion is correct as is the UsedRange. As noted I can get around it by copying the cells to a new sheet, but it's got me "bugged". Any hints? -- Regards Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
get sort to recognize header row | Excel Discussion (Misc queries) | |||
Sort does not recognize the header row | New Users to Excel | |||
how do i set the default sort option to recognize a header | Excel Discussion (Misc queries) | |||
excel change default column sort to current selection | Excel Worksheet Functions | |||
I want to sort data randomly in addition to the current descendin. | Excel Worksheet Functions |