Pivot table autoformat info
 

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.

Pivot table autoformat info
 

You can use Format:

ActiveSheet.PivotTables(1).Format xlTable10

ActiveSheet.PivotTables(1).Format xlColor1 'like Report8


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.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Pivot table autoformat info
 

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

kind regards.
UD

"Debra Dalgleish" wrote:

You can use Format:

ActiveSheet.PivotTables(1).Format xlTable10

ActiveSheet.PivotTables(1).Format xlColor1 'like Report8


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.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Pivot table autoformat info
 

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.