Tags: blanks, cells, create, creates, excel, filter, goback, hide, hidesall, hii, ideas, macro, microsoft, msdn, pivot, records, software, table, tables, vba

vba pivot tables and hide blank cells

On Microsoft » Microsoft Excel

1,061 words with 1 Comments; publish: Wed, 28 May 2008 22:47:00 GMT; (306139.65, « »)

Hi

i need to create a vba macro which creates a pivot table and also hides

all blanks. Any ideas? I am still trying to filter out records which go

back to 1996, only keeping the 2004 records.

thanks

Message posted from http://www.mcse.ms/

All Comments

Leave a comment...

  • 1 Comments
    • Post this question in the "microsoft.public.excel.charting" newsgroup. Debra

      D. hangs out there and she's a wiz with pivot table :-)

      Toby Erkson

      Oregon, USA

      Excel 2002 in Windows XP

      "rbekka33 >" <<rbekka33.1cj0v4.excel.todaysummary.com.excelforum-nospam.com> wrote in message

      news:rbekka33.1cj0v4.excel.todaysummary.com.excelforum-nospam.com...

      > Hi

      > i need to create a vba macro which creates a pivot table and also hides

      > all blanks. Any ideas? I am still trying to filter out records which go

      > back to 1996, only keeping the 2004 records.

      > thanks

      >

      > --

      > Message posted from http://www.mcse.ms/

      >

      #1; Wed, 28 May 2008 22:48:00 GMT