read cells of a column of a pivot table

[ali_hijazi]

hello

is there a way to read the cells of a column of a pivot table using macros?

[swuehl]

Maybe using GetCell() function?

Like (from the API examples):

set table = ActiveDocument.GetSheetObject( "CH01" )

for RowIter = 0 to table.GetRowCount-1

    for ColIter =0 to table.GetColumnCount-1

        set cell = table.GetCell(RowIter,ColIter)

        msgbox(cell.Text)

    next

next

Regards,

Stefan

[ali_hijazi]

Actually the above example is not helpful

what I want is actually display in a pivot table only the rows with non null cells

[swuehl]

ali_hijazi wrote:

is there a way to read the cells of a column of a pivot table using macros?

This was your original question, wasn't it?