Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |