Counting Used Cells in a Range

[Cyberdude]

If I write

Msgbox Range("A1:A10").count

I get the number of rows in the range.
How do I write a statement using .Count to get a count of the number of used cells in the range?

[Jacob Hilderbrand]

You need to specify what you want to count, in this case Cells.

Msgbox Range("A1:A10").Cells.Count

Now what do you mean by used cells? Only cells with values or all cells in the range. If you only want cells with certain values you can use SpecialCells to narrow the range.

[Cyberdude]

You pretty much told me what I was missing. I just want to know how many of the cells in a column have values.
I'll investigate the SpecialCells to see what possibilities it offers. Thanx drj!

[Jacob Hilderbrand]

You're Welcome

Take Care

[sheeeng]

You need to specify what you want to count, in this case Cells.

Msgbox Range("A1:A10").Cells.Count

Now what do you mean by used cells? Only cells with values or all cells in the range. If you only want cells with certain values you can use SpecialCells to narrow the range.

.Count
Simple yet I forgot...
I must be getting old...