I guess you are looking for field names. DId you try the PivotField object?

Kanan

" wrote:

I have a table of data that I have a macro creating a pivot table out
of. I select a cell out of the row titles but it shows the cell value
is "". I even tried cells.find to look for the word but that doesn't
find the cell I am looking for. Manually I can do it and find the cell
or click on it and see the value but when I run the macro it doesn't
see the values. I have even tried copying the whole table and pasting
values so it doesn't see it as a pivot table anymore. Any help is
appreciated.

Thanks