Pivot Table Errors

R

Rich

Hi,

I am using a pivot table with date ranges being modifiued by VBA.
The code I use to alter the date ranges is:

With ActiveSheet.PivotTables("PivotTable1").PivotFields("Activity Date")
.PivotItems("<" & Start_Date).Visible = False
.PivotItems(">" & End_Date).Visible = False
End With

Whilst this works on my machine, and also the guy sitting next to me, it
does not work on several other machines...all with Excel 2007 installed.

Start_Date and End_Date are variables.

Any clues?
 

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

VBA Pivot Table Error 1
Pivot table - unwanted lines 2
Pivot Table Filtering - Macro 3
Pivot Table Help 1
Pivot Table - How do I "Show All Data" of a particular field? 6
VBA, Macros and Pivot Tables 1
Dynamic Pivot Item Selection 1
Pivot Table Macro, exclude possible blanks 0

Top