Vba variabel problem

[beerger]

Namnlös.png

Hello!

Please Login or Register  to view this content.

I would like som help with some vba. Im very new to this. Not excel, but vba. What I am trying to do is put c2:s value inside of the [] that refers to the array. So depending on what value i put in c2 I want that value to be between []. Im using the variabel "city" to try to solve this.

When trying to run the macro it says "run-time error 1004:" and "The items could not be found in the OLAP Cube". Any thoughts on what I could do? Would really appreciate help

[beerger]

Hope the edits I did are sufficient. Thanks for telling me