View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wessman wessman is offline
external usenet poster
 
Posts: 1
Default 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.