Excel 2000 VBA Subtotals help

[rhodyman10]

I am using Microsoft Excel 2000 and Windows 2000.

I have created code to do subtotals on unique values on column A.

It then creates subtotals on unique values on column C.

I would like to put code in that breaks out the values for
specific values on column A. When it is done, I want it
to indent and show all the unique values for column C,
but keep their plus signs, so that the endusers can click on them,
if they choose. There are only *two* unique codes on column A that
I need to do this to.

It would really be a big plus if I can do this with code with the
computer's help. I have a number of reports that I am doing this to
manually.

Thank you in advance for your help.

 

[Cindy M.]

I am using Microsoft Excel 2000 and Windows 2000.

I have created code to do subtotals on unique values on column A.

It then creates subtotals on unique values on column C.

Try asking this in the excel.programming newsgroup, where the Excel
specialists congregate.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17
2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail