View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default 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