Reply to thread

Message: [QUOTE="Mouimet, post: 6423541"] Hi, IN VBA how can I select only the data I need in the Pivot Table Page section. Need to get only the data <45 in column "Days" "Days" is in the Page Section of the pivottable. The user will only click a button to answer different questions, and generate a new data sheets base on is criterias and then, the pivot table is refresh. the user will not select any other data.Most of the macro is ok. My problem is only selecting the <45. On the Page fields the pivot table should always select "DAYS" <45. from the data. I tried different macro and I can't find the solution. I found something usefull on the newsgroups however when the macro do not see any data smaller than 45 it stop with an error message. Please help. Thanks [/QUOTE]