View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
[email protected] beancurdjelly2003@yahoo.com.hk is offline
external usenet poster
 
Posts: 35
Default macro on pivot tables / pivot items

Still show error message 1004 when success to split out on the first
of PivotField
name....(only success save 1 file)
But the format are ok, how the split out file need the drill data?
How can i do? Can I run the Pivot Table's name (Sheet name) instead
of PivotTable1?