Subtotal(5,range) says to return the Minumum value in the range. Is one of
the the cells being subtotalled returning a zero?

--
Regards,
Tom Ogilvy

"jeff" wrote in message
...
I have a series of columns with sums at the top of each using the SUM()
function. I want to run the subtotal command across them from VBA using
range
("a1")= Worksheetfunction.subtotal(5, Range). But I keep getting back a
zero
for the result although the columns have numbers in them. Is this due to a
flaw with trying to use the SUM() Function or have I gone Crazy.

Jeff