| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.SpecialCells(xlLastCell).Select
in readin an article at
http://j-walk.com/ss/excel/tips/tip73.htm Automatically Resetting the Last Cell everything i have read about excel's problem of resetting the last cell refers to excel 97. im running excel2000 winxp and have this problem too. (including all office, winxp updates) i've even selected the entire sheet and cleared it Worksheets(2).Cells.Clear this still doesnt work... the solution in the article works fine. Does anyone else have this problem with excel 2000? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Work around to SpecialCells(xlCellTypeBlanks)... | Excel Discussion (Misc queries) | |||
| Specialcells | Charts and Charting in Excel | |||
| VBA ON ERROR does not work with SPECIALCELLS | Excel Discussion (Misc queries) | |||
| Cntrl + End (xlLastCell) | Excel Discussion (Misc queries) | |||
| XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select | Excel Programming | |||
Threaded Mode
