LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 25
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
get sort to recognize header row widman Excel Discussion (Misc queries) 3 October 25th 06 04:14 AM
Sort does not recognize the header row Notbefore10 New Users to Excel 4 October 25th 06 02:27 AM
how do i set the default sort option to recognize a header marquize Excel Discussion (Misc queries) 1 July 7th 06 04:54 PM
excel change default column sort to current selection john palmer Excel Worksheet Functions 2 March 8th 05 03:07 PM
I want to sort data randomly in addition to the current descendin. ckephart Excel Worksheet Functions 2 November 12th 04 06:11 PM


All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"