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...