how many rows did I selected

P

Paul Ho

Hi,

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

Thanks!
Paul
 
N

Norman Jones

Hi Paul,

Assiming you are referring to VBA, try:

Dim NumOfRows As Long

NumOfRows = Selection.Rows.Count
 
Top