Take a look at the pivot table options in Excel, you can specify the
grouping variables (for sub totalling) and the sumary statistics you
require. Far better than writing VBA code to do it.

Cheers
Nigel

"Mervyn Thomas" wrote in message
...
Has anyone any code for subtotalling the same as the built in facility
EXCEPT not to subtotal where there is only one line of data? Also on
true
subtotal lines it would be useful to sum some columns, average others and
count others but perhaps I am getting too complicated!







----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---