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