Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks,
That's what I need |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count filled cells in range if they are one after the other | Excel Worksheet Functions | |||
How do I get a count of number of cells filled in? | Excel Discussion (Misc queries) | |||
Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
Count Rang of Filled-In Cells | Excel Worksheet Functions | |||
Count no. of filled cells in a column | Excel Programming |