| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select
I can use the following to select all the "active" cells:
Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select ....but why can't I use the following to select JUST the last active cell? Range(ActiveCell.SpecialCells(xlLastCell)).Select ....am I missing something? I'm trying to get the Row Number of the last active cell on a sheet and pass it to the next line in the macro. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| please change Range("AB30").Select to any cell | Excel Worksheet Functions | |||
| "Select method of Range class failed" Error | Excel Discussion (Misc queries) | |||
| Using "=randbetween" to select a number from a range of cells | Excel Worksheet Functions | |||
| Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
| Range("cell").Select Problem | Excel Discussion (Misc queries) | |||
Threaded Mode
