COUNTA Function in VBA

Hi All,

I have a column with dates (UK format). What I want to do is select a range in that columns and count the number there are, i.e:

Column A

01/03/2007
02/03/2007
03/03/2007
04/03/2007
05/03/2007

Say I select rows 2 to 3 in column A, when I run the macro I want a msgBox to return, "You selected 3". This is what I have:

Please Login or Register  to view this content.

My problem is, that the function keeps returning 1, no matter how many I select. I have attached an example for you to look at

Thanks,
mccreaso

Hello Mccreaso,

The reasone the macro is returning a 1 is you are using the address of the Range (selection) and not the Range object itself. Here is the ammended code...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Originally Posted by Leith Ross

Hello Mccreaso,

Please Login or Register  to view this content.

Sincerely,
Leith Ross

thanks Leith,

Works Great!
mccreaso

Thank you for the great sharing.

You can also select entire column A with this code

Please Login or Register  to view this content.