Control-Shift-End is wrong

[combatvolcano]

Hello,

When I use control+shift+end to try to select to the bottom right portion of a sheet it selects far, far further out than my data.

My data occupies A1:BR9564, when I use control+shift+end I end up at RZ14563.

All other cells contain no data. I can even highlight the blank cells, hit delete and try again and I get the same result.

This

Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select

is a very important programmatic feature and I need it to work correctly. Any ideas on what is going on here or how to correct it?

Edit: Control Shift Right then Control Shift down does indeed work. What's wrong with xlLastCell???


Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select

 

[Jonmo1]

I hear ya Jonmo, unfortunately none of those things are true... I simply didn't use a row that far down or a column that far out on that sheet or any sheet in my book or any other book... really, I'd love to know the actual cause of this, but it's not because I used that range anywhere at all.

Anyone know where in the environment xllastcell is stored? (or what it uses to get it's ranges when called?)

If I could track the numbers out of excel as they change I could possibly track this down.

So you NEVER inserted a row and/or column?
Insert Cut cells
or Insert Copied Cells