Hi
what is your exact code and how have you defined 'range'

--
Regards
Frank Kabel
Frankfurt, Germany

jeff wrote:
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