Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
is there a way to read the cells of a column of a pivot table using macros?
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
Actually the above example is not helpful
what I want is actually display in a pivot table only the rows with non null cells
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?