Hi,
I have a pivot table referenced to OLAP Cube where I need the filter one off the filters updated to include on user defined codes on the running of a macro. This what I've got so far:
This falls over every time with a 'Application-defined or object-defined error'. If however I have the macro input the result into the sheet (i.e. Code.Cells(2, 5) = CodeID) and paste that directly into the code, then it works fine. Below is an example of that:Please Login or Register to view this content.
Any help would be greatly appreciated!Please Login or Register to view this content.
Bookmarks