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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select
Hi wessman
Don't use SpecialCells(xlLastCell) or UsedRange.Rows.Count It don't always give you a correct answer You can use a function See a example here http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "wessman" wrote in message m... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select
try:
ActiveCell.SpecialCells(xlLastCell).Select Francisco Mariscal fcomariscal at hotmail dot com -----Original Message----- 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)).Sele ct ....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. . |
Reply |
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) |