how many rows did I selected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

For example, I have selected cells(A1..E5). Any function can tell me I have
selected 5 rows (in this example)?

Thanks!
Paul
 
Hi Paul,

Assiming you are referring to VBA, try:

Dim NumOfRows As Long

NumOfRows = Selection.Rows.Count
 
You must log in or register to reply here.

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

How many rows have I selected ? 6
Sliding scale for Mark Up 0
Function to Return a Date Value Q 4
Selecting rows. 3
Select rows which satisfy 2 criteria 16
Create an array of separate cells 1
Excel Summarization of indexed column 1
tab order for multi-range selections 1

Back
Top