Look at the WorksheetFunction Property (of the Application object)... the
count and sum functions are all available through it.

--
Rick (MVP - Excel)


"Chris Freeman" wrote in message
...
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