Excel:Counting the number of cells in an array

[JMcKC]

How can I, using one Function, count the number of cells
in an array.

I worked around it using the product of the Rows Function
& the Columns function. Couldn't find a single Function
to acomplish the task


Thanks,


JMcKC

 

[Vasant Nanavati]

MyRange.Cells.Count

 

[Peo Sjoblom]

That is the only way unless you roll your own function