VBA counting used entries in a range

[f_mayr]

hey

i need to count the number of used entries in a range.

so fex the range is A1:A10 but there are only 2 entries what i search is the number 2

is there a VBA function or so doing that.

ps i have this range.Rows.Count but this is counting me the length of the range even if there are no entries..

thanks

[DonkeyOte]

Without knowing how A1:A10 are populated (ie are they blanks or formula nulls ?) it's hard to give precise answer but you could try:

Please Login or Register  to view this content.

[f_mayr]

nope thats not working. it just gives me 1 even if there are 3 entries in the range

the entries are dates and if there is no entry it is just blank...

[DonkeyOte]

Post a sample where you are getting 1 rather than 3... are you referencing the correct range ? Is your range as straight forward as A1:A10 or is it being set by some other code etc ?

[f_mayr]

im sorry now its working. i used a false range.

thanks alot!