Error 1004 impossible to capture with On Error go To

If the pivot table doesnt have the element you are trying to use as filter I think that the line

Please Login or Register  to view this content.

will give back error. If this is the case, then the On Error statement needs to go before it:

Please Login or Register  to view this content.

Try it like that and get back please

I hope that helps.

Originally Posted by Pichingualas

If the pivot table doesnt have the element you are trying to use as filter I think that the line

Please Login or Register  to view this content.

will give back error. If this is the case, then the On Error statement needs to go before it:

Please Login or Register  to view this content.

Try it like that and get back please

I hope that helps.

Back error... that's right. I ignored that. Thanks for your help, that worked perfectly.

+1

Awesome

Hello,

I have re-tested the code again and I have discovered that it ALWAYS prompts the ERROR control. What is more, now the code is quite slow...

Here's my code:

Please Login or Register  to view this content.