XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select

[wessman]

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.

 

[Ron de Bruin]

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

 

[pancho]

try:
ActiveCell.SpecialCells(xlLastCell).Select




Francisco Mariscal
fcomariscal at hotmail dot com