Cell value without columns

B

bttfrc

hi,
I've a pivottable that have on row "customers" and on columns only a
measures "sales", i.e. on columns i haven't dimension.
I've try to read value by
pivottable.activedata.cells(RowAxis.Member.ChildMembers(0),ColumnsAxis.Member.ChildMembers(0))
but there isn't columns members so VB return error.
How can I read "Sales" data ?

! Measures.Sales
---------------------------------------------------
Customer 1 ! 12343
Customer 2 ! 42443
Customer 3 ! 55567

thanks
federico
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell value without columns, driving me mad 3
formula patterns with a gap of two 0
Pivot Table Data Column Sort Excel 2007 1
Web Components Toolpack Bug 0
Multi-select list box 1
URL Action still a problem? 0
pivot table - shows zero when should not be 1
Goal Seek with variable Set Cell 1

Top