Re: Delete a Pivot Table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Dean,
The help file is not much help on this one.
(I think the summer intern must have come up with this one)<g>

ActiveSheet.PivotTables("name").TableRange2.Clear
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"SaeOngJeeMa"
<SaeOngJeeMa@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message
I have a Worksheet with a bunch of Controls (combo boxes, text boxes, etc)
and a Pivot Table. I need to be able to programmatically delete or remove the
Pivot Table without deleting the Worksheet (because I need to keep the
Controls intact). Does anyone know how to do that? BTW, even if it can't be
done programmatically, is there a way to do it manually? Thanks in advance.
Best Regards,
Dean
.

Relevant Pages

  • Re: OWC11 PivotTable Help File Wrong
    ... However, the help file programming ... the pivot table object, it explains concepts for the OWC in general. ... chart> Microsoft Office Chart workspaces examples and Creating an ... > Everything in the OWCDPL11.CHM file is fine except the Programming ...
    (microsoft.public.office.developer.web.components)
  • Re: Would like to know of any tutorials out there on MS access
    ... series book. ... If programming, ... When MS came out with the help files for Access in A2000 and more recent versions, the entire Access community should have blasted the help file system and sent nasty letters to MS, and told them the help file system was totally unacceptable. ... I would think that anyone on the MS help file projects, at least for Access, should go home at nights filled with guilt for putting out such a shitty product. ...
    (comp.databases.ms-access)
  • Re: Macro to Break Links Before Saving Sheet
    ... Did you look at the help file as I suggested? ... (Excel Add-ins / Excel Programming) ... Well, because of the formatting, everything gets really screwed up if I try ... to copy and paste to a new sheet. ...
    (microsoft.public.excel.programming)
  • Re: F1 help
    ... > for Pocket PC 2003 and created the html help file. ... > I'm running the ppc application I wrote. ... > the programming running, tap the start button and then tap help. ... > "Daniel Moth" wrote: ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: How to talk to hardware devices in C
    ... hardware device such as a video card or modem? ... Linux C programming versus Microsoft C programming? ... device filtering drivers for the fun of tinkering with the Windows OS, ... and the DDK's help file for Win32 taught me a ton about the ...
    (comp.lang.c)