Count from A5 down to last used row - Not up

[Les]

Hi all,

Is it possible to count the used rows from A5 down to the last used row ?

As i have data further down in column A, so cannot count up.

 

[Jim Thomlinson]

Use xlDown instead of xlUp...

dim rng as range

set rng = range(range("a5"), range("A5").end(xlDown))
msgbox rng.count

 

[Les]

Thanks Jim, much appreciated

--
Les

Use xlDown instead of xlUp...

dim rng as range

set rng = range(range("a5"), range("A5").end(xlDown))
msgbox rng.count