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.

Hi Steve

You've practically got it!!
countrows = Selection.Rows.Count
--
Regards
Roger Govier

"SteveM" <(E-Mail Removed)> wrote in message
news:32DE5A5A-02CC-4B7B-A868-(E-Mail Removed)...
> 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.
>

hi
Dim c As Long
c = Selection.Rows.Count
MsgBox c

regards
FSt1

"SteveM" wrote:

> 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.
>

Thank you Roger & FSt1 for the quick replies.

S.