combatvolcano
Board Regular
- Joined
- Jan 13, 2010
- Messages
- 69
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
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
Last edited: