How do I count the number of rows selected?

S

SteveM

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AppleScript - How do I select a text ? 1
Quickly count used rows? 5
Unable to delete rows for only filtered results 6
Code to add comments to selected cells within a selected range 30
Count down a certain number of rows? 5
How do I choose the rows that are filtered ? 1
Everchanging number of rows 5
How can I print rows that go outside of the page without shrinking the text? 0

Top