vba for pivot

  1. pedie

    VBA to select drop down from PIVOT getting error '1004'. Please help.

    Hi, I am trying to make the vba select the pivot table drop down and then copy the selection and paste it so that it can be ready to be exported to some other sheets but seems like I am doing something wrong. Run time error '1004' Please help. Thanks Pedie below is my recorded code...

Some videos you may like

This Week's Hot Topics