Filtering OLAP Pivot Table by array

Hi all,

I am trying to filter a Pivot Table that has a OLAP source, by multiple ItemId's in the worksheet.

The values that I want to filter by is in cell A2 and down. The list of ItemId's that should be visible in the Pivot Table could be anything from 1 to 500

As a small test i wrote the following line of code, and it works great.

Please Login or Register  to view this content.

However, when using a variable (ITEMID) I only get a Run-time Error '1004'.

Please Login or Register  to view this content.

Any help would be appreciated!

Cross-posted here: https://www.mrexcel.com/forum/excel-...ble-array.html

Thank you!

Split did unfortunately not work as well as i had hoped.

How would i go forward to populate an array in the first place?