Run-Time error '1004'

[kaseyleigh]

Hi,

I get Run-Time error '1004' and I think it's because my sheet doesn't have focus when trying to select the Pivot Tables, I need some assistance and correcting my code.

I have 3 sheets, 1, 2 & 3 and there are Pivot Tables on 2 & 3 only.

Please amend my code so it can run more efficiently. Also, if you have any tips I'd be very grateful too.

Much appreciated,
K

Please Login or Register  to view this content.

[Andrew-R]

Hi, could you please read the forum rules and use code tags around your code - once you've done that I'm sure somebody will by happy to help you.