View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stevem stevem is offline
external usenet poster
 
Posts: 29
Default How do I count the number of rows selected?

I want to find out how many rows are in my selected range after issuing these
lines:

Range("A2").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell).Offset(0, -1)).Select

I don't know how to go from there. Is there a row property I can use to
capture the count of rows (something like countrows = selection.rows)? As
you can tell, I'm pretty much a novice at this. Thanks in advance,
S.