Finding data in pivot table

[Tony Elmore]

I have a pivot table using OWC on an ASP page that I want to retrieve the
data from a particular row when a button is pressed in order to send this
data to another page. My problem is that I don't know how to find the name
of the row that I'm working with. If I specifically state that it is the
second row then it all works fine (shown below)... how can I get the heading
for that row to ensure it is the desired data?

// loop thru all first level row members
for (rOneIndex = 0; rOneIndex < oData.RowMembers.Count; rOneIndex++) {
rowOneMembers = oData.RowMembers(rOneIndex);
// now loop thru all second level members and get the caption - this is
where I want to check the column heading to make sure it is the column I
want
for (rTwoIndex=0; rTwoIndex < rowOneMembers.ChildMembers.Count;
rTwoIndex++) {
rowTwo = rowOneMembers.ChildMembers(rTwoIndex);
strValue = strValue + ",'" + rowTwo.Caption + "'"; }
}
}

All assistance appreciated...