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

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

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