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