vba pivot tables and hide blank cells

  • Thread starter Thread starter rbekka33
  • Start date Start date
R

rbekka33

Hi

i need to create a vba macro which creates a pivot table and also hide
all blanks. Any ideas? I am still trying to filter out records which g
back to 1996, only keeping the 2004 records.

thank
 
Post this question in the "microsoft.public.excel.charting" newsgroup. Debra
D. hangs out there and she's a wiz with pivot table :-)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Language independent VBA - hiding "blank" in pivot? 1
Using VBA to create charts 1
relative reference pivot table macro 2
Playing back a Pivot Table macros 2
create a pivot table and chart from a named range 1
VBA Pivot Table Error 1
Corrupt files due to pivot remnants after saving via VBA 0
Unable to Group in Pivot Table 1

Back
Top