| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - How to exclude info without showing? | Excel Worksheet Functions | |||
| Pivot Table Col 1 & 2 to display info in rows | Excel Discussion (Misc queries) | |||
| Can I "customize" an autoformat report for a Pivot Table in Excel | Excel Discussion (Misc queries) | |||
| combining 3 columns of same info for a pivot table | Excel Worksheet Functions | |||
| Extract pivot table info | Excel Programming | |||
Linear Mode
