View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Freeman Chris Freeman is offline
external usenet poster
 
Posts: 13
Default Count Num and Sum functions as a variable


I have a sheet that I need to count the number of items in a column and also
sum them. I can add a formula to cell, collect the values to a variable, then
clear the cell, but I was trying to figure out a more elegant internal code.
I wanted to caputure the number of items in the column without looping.
problem is that some rows are blank, and Selection.Rows.Count brings back all
rows.

Thanks
---------------------------------
Chris Freeman
IT Project Coordinator