Number of rows within a range

[Guitarde]

I usually use the following code to get the number of rows:
Range("data").Select
vNbRow = Selection.Rows.Count

Is there a way to get this without any Select
...something like Range("data").Rows.Count (this is not working).


Thanks
Eric

 

[Norie]

Eric

How is it not working?

Is this what you are trying? It seems to work for me.

vNbRow = Range("data").Rows.Count