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


Reply With QuoteReply With Quote