Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Count property returns the number of cells in a range (all cells, not just the nonblank cells) Its a read-only property

Sub count()     MsgBox range("A1:C3").count End Sub