count filled cells
 

Is there a vba macro, that count's filled cells in a column
down to the last cell, from any active cell in the given column.
Using one column at a time.
Then, reports the result as a box message.

With Thanks

count filled cells
 

Sub UsedCellsFromHereToEnd()
MsgBox Application.CountIf(Range(ActiveCell,Cells _
(Rows.Count,ActiveCell.Column).End(xlUp)),"<""")
End Sub

Is that what you are after?

Charles
smandula wrote:
Is there a vba macro, that count's filled cells in a column
down to the last cell, from any active cell in the given column.
Using one column at a time.
Then, reports the result as a box message.

With Thanks

count filled cells
 

Thanks,

That's what I need