Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting the number of nonempty cells
I want to count the number of nonempty cells in column A. However, I do not
want to start with cell A1. I want to begin counting in cell A4. Then I would llike to assign this value to a variable. Any help would be greatly appreciated. Thanks sc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting the number of nonempty cells
Hi SC,
Try: Sub Tester() Dim rng As Range Dim iCtr As Long Set rng = Range("A4:A" & Rows.Count) i = Application.CountA(rng) 'Return count of populated cells MsgBox iCtr End Sub --- Regards, Norman "Steve" wrote in message ... I want to count the number of nonempty cells in column A. However, I do not want to start with cell A1. I want to begin counting in cell A4. Then I would llike to assign this value to a variable. Any help would be greatly appreciated. Thanks sc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number of cells | Excel Worksheet Functions | |||
Counting number of cells that match name AND number | Excel Worksheet Functions | |||
Counting the number of cells that have the same value | Excel Worksheet Functions | |||
Counting the number of same value cells | Excel Discussion (Misc queries) | |||
List the one nonempty cell | Excel Discussion (Misc queries) |