Turn on the macro recorder while you manually do what Peter suggested. That
should give you the attributes you need to work with to control you table.

If all your data is numeric, then excel will default to Sum of, but if there
is non-numeric or I think, even a blank field, it will default to Count of,
so you need to control it explicitly.

--
Regards,
Tom Ogilvy
"Sugith Kumar" wrote in message
...
Thanks for the quick reply. But here I need to control the
Excel sheet thru the VB Program. Because of the "Count of"
all the values in that field are appearing as 1. They are
actually holding diffrent values like 22.0, 25.2 etc

Thanks
Sugith