Thread: Pivot table autoformat info
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default 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

Reply With QuoteReply With Quote