Good old runtime error 5 question

[martystoked]

I have also posted this problem in another forum here:
http://www.thecodecage.com/forumz/mi...post1055009266

Anyone got any ideas here is my code:

Its Breaking here:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[romperstomper]

Is the item visible in slicer 2?

[martystoked]

Is the item visible in slicer 2?

Yes the item is sometimes in slicer 2. But for the sake of testing it I picked an item that is in both

[romperstomper]

Ah, that property uses an array so you probably require an index number, not a name, to access its elements.

[martystoked]

Ah, that property uses an array so you probably require an index number, not a name, to access its elements.

For some weird reason when I opened the file this moring there was no error 5 . But the code still is not syncing up the second slicer cache with the first slicer cache. Any ideas?

[JosephP]

you've gotta loop through all the items in the second cache not just the visible ones and you don't want the If test

Please Login or Register  to view this content.

for instance

[martystoked]

you've gotta loop through all the items in the second cache not just the visible ones and you don't want the If test

Please Login or Register  to view this content.

for instance

When I do that I now get a run-time error #5 Invalaid Procedure call or argument.

and it fails on this code

Please Login or Register  to view this content.

[JosephP]

then I reckon you've got items in one slicer cache that aren't in the other so you can't guarantee real synchronization

[martystoked]

then I reckon you've got items in one slicer cache that aren't in the other so you can't guarantee real synchronization

This is true. Is there still a way to do it? To select items that are in one slicer if the same items exist in the other? else done select anything??

[JosephP]

simple way would be to ignore errors

Please Login or Register  to view this content.

[martystoked]

simple way would be to ignore errors

Please Login or Register  to view this content.

This kind of works...similar to what I had before...but:

First off it takes forever to run since there are a ton of slicer items.
Second when I only have 1 person selected the code selects 3 people in the other slicer. Their names are not even similar, so I am not sure why that is even happening.

That was why I was trying to check only for selected slicer items.

Thoughts?

[romperstomper]

The code only processes items present in slicer 1, so if there are items in slicer 2 that aren't in slicer 1 they will be left selected.