?Hi Anill ,
Sorry for late reply ,
below is macro code record.
Range("C8").Select
With ActiveSheet.PivotTables("PivotTable1").PivotFields("Transaction
Type")
.PivotItems("Accept").Visible = False
.PivotItems("Return to Receiving").Visible = False
.PivotItems("Return to Supplier").Visible = False
.PivotItems("(blank)").Visible = False
End With
I have pivotitem 6 item are accept , return to receiving , return to
supplier , blank , receive , delivery
when I refresh data macor was not work coz pivotitem had less than 6 items.
some time will no blank item or no return .... item
actually I need data only 2 pivotitem are receive and delivery.I don't know
how to set only receive and delivery item.
Thanks,
WKH8919
2010/1/20 Anil <[email protected]>
> Hi WKH8919,
>
> I would like to see the recorded macro code.
>
> Regars,
> Anil
>
> On Jan 20, 2:52 pm, WKH8919 <[email protected]> wrote:
> > Hi
> > I just start to learn about macro and need expert to advise.
> >
> > Now I have pivotable and I record macro that will select 2 pivotItems
> > from pivotfields but some time pivotfields will container different
> > number of pivotItem
> >
> > then when i run macro it's not work , I don't know why ?
> >
> > May some one help me ?
> >
> > Sorry for my english not good.
> > Thanks
> > WKH8919
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to [email protected]
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ [email protected]
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
If you find any spam message in the group, please send an email to:
Ayush Jain @ [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
