Hi,

Any function that could tell me how many rows have I selected?
i.e. I have selected cells(A1:E5), the function could show me 5 row.

Thanks

Hi Paul,

Assiming you are referring to VBA, try:

Dim NumOfRows As Long

NumOfRows = Selection.Rows.Count

---
Regards,
Norman


"Paul Ho" wrote in message
...
Hi,

Any function that could tell me how many rows have I selected?
i.e. I have selected cells(A1:E5), the function could show me 5 row.

Thanks

Hi, Norman,

Thanks for you help. But I need is function, not VBA. Is it any?

Regards
Paul

"Norman Jones" wrote:

Hi Paul,

Assiming you are referring to VBA, try:

Dim NumOfRows As Long

NumOfRows = Selection.Rows.Count

---
Regards,
Norman


"Paul Ho" wrote in message
...
Hi,

Any function that could tell me how many rows have I selected?
i.e. I have selected cells(A1:E5), the function could show me 5 row.

Thanks

There is no worksheet function for this. Take Norman's suggestion and
write it as a VBA User Defined Function

Function rowsSelected()
Application.Volatile
rowsSelected = Selection.Rows.Count
End Function

Declaring the the function to be volatile is necessary to get it to
recalculate in future recalculation events.

Jerry

Paul Ho wrote:

Hi, Norman,

Thanks for you help. But I need is function, not VBA. Is it any?

Regards
Paul

"Norman Jones" wrote:


Hi Paul,

Assiming you are referring to VBA, try:

Dim NumOfRows As Long

NumOfRows = Selection.Rows.Count

---
Regards,
Norman


"Paul Ho" wrote in message
...

Hi,

Any function that could tell me how many rows have I selected?
i.e. I have selected cells(A1:E5), the function could show me 5 row.

Thanks

No, you can count the rows in a specified range, but not the selection.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul Ho" wrote in message
...
Hi, Norman,

Thanks for you help. But I need is function, not VBA. Is it any?

Regards
Paul

"Norman Jones" wrote:

Hi Paul,

Assiming you are referring to VBA, try:

Dim NumOfRows As Long

NumOfRows = Selection.Rows.Count

---
Regards,
Norman


"Paul Ho" wrote in message
...
Hi,

Any function that could tell me how many rows have I selected?
i.e. I have selected cells(A1:E5), the function could show me 5 row.

Thanks

Thanks everybody!

"Jerry W. Lewis" wrote:

There is no worksheet function for this. Take Norman's suggestion and
write it as a VBA User Defined Function

Function rowsSelected()
Application.Volatile
rowsSelected = Selection.Rows.Count
End Function

Declaring the the function to be volatile is necessary to get it to
recalculate in future recalculation events.

Jerry

Paul Ho wrote:

Hi, Norman,

Thanks for you help. But I need is function, not VBA. Is it any?

Regards
Paul

"Norman Jones" wrote:


Hi Paul,

Assiming you are referring to VBA, try:

Dim NumOfRows As Long

NumOfRows = Selection.Rows.Count

---
Regards,
Norman


"Paul Ho" wrote in message
...

Hi,

Any function that could tell me how many rows have I selected?
i.e. I have selected cells(A1:E5), the function could show me 5 row.

Thanks

You also have to force a recalc after selecting a range, the selection
itself won't do it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jerry W. Lewis" wrote in message
...
There is no worksheet function for this. Take Norman's suggestion and
write it as a VBA User Defined Function

Function rowsSelected()
Application.Volatile
rowsSelected = Selection.Rows.Count
End Function

Declaring the the function to be volatile is necessary to get it to
recalculate in future recalculation events.

Jerry

Paul Ho wrote:

Hi, Norman,

Thanks for you help. But I need is function, not VBA. Is it any?

Regards
Paul

"Norman Jones" wrote:


Hi Paul,

Assiming you are referring to VBA, try:

Dim NumOfRows As Long

NumOfRows = Selection.Rows.Count

---
Regards,
Norman


"Paul Ho" wrote in message
...

Hi,

Any function that could tell me how many rows have I selected?
i.e. I have selected cells(A1:E5), the function could show me 5 row.

Thanks