Ignore Error in VBA

[ZeDoctor]

Hi peeps,

I've currently got a VBA macro that currently filters 4 pivot tables based off a cell value. The problem is, occasionally, the text typed into the cell (K2) won't be an option within the pivot table filter. I want the macro to then bypass this pivot and not touch this filter.

I've tried using On error Resume Next but to no avail.

Any helps appreciated.

Cheers,

Please Login or Register  to view this content.

[Izandol]

You may try:

Please Login or Register  to view this content.

[ZeDoctor]

Works an absolute treat, thanks so much Izandol.

Can I be cheeky and ask if it's possible to also add a textbox pop up in, giving a warning to the user that the pivot hasn't been updated?

[Izandol]

Of course - it is only small change:

Please Login or Register  to view this content.

[ZeDoctor]

You're a god among men. Thanks so much.

[Izandol]

You are welcome. Please remember to mark this question solved.

[ZeDoctor]

Sorry to bring this thread back up but I'm now receiving a run time error with the line ".CurrentPage = vValue" highlighted on the second part of the code.

I can't for the life of me figure out why it's that highlighted.

Any helps appreciated.

[Izandol]

What is vValue data type? Is it date?

[ZeDoctor]

I have no idea which data the VValue is Is that the field we are amending in the pivot table? If so, it's text..

[Izandol]

Please change FilterField routine:

Please Login or Register  to view this content.

and run code again and report value given in error message.

[ZeDoctor]

Thanks very much for your help on this btw.

Just run it and got the error "Error occurred setting filter to value:Roncalli" (Roncalli is the name of a salesperson in cell K2)

[Izandol]

Is there data for this salesperson in all pivot tables?

[ZeDoctor]

Nope, that's what I'm guessing is the problem.

But I thought you had set this up so it would bypass the pivot tables where he has no data

[Izandol]

If data does not exist now, but did before, it may be retained in pivot item list. In pivot table options, you may set retained item limit to none and test again. If this does not resolve problem, please post sample workbook?

[ZeDoctor]

Is there anything you can't do Izandol? You're a genius.

A million thank you's