Hi
Thanks for your reply. The code shown below is to set a format to a pivot
table.. but how do I retrieve an existing format?

with regards
UD

"UD" wrote:

Hi All

I want to find out whether 'color1' or 'table10' autoformat is set to a
pivot tabel. I've looked in the PivotTable class couldnt find anything
there. How do I achieve that in vb6?

Many thanks in advance.
with regards
UD.