Hi all,
I am new to macro's and this is my first one. I have trouble to get my pivot table to work in different sheets. In the syntax there is a hardcoded sourcedata which I think creates the error. Instead of this fixed name, it should be the name of the worksheet in which I want to execute the macro.
Anyone a line of advice? Underneath is the syntax, the line which I think is the troublemaker is in bold.
thx in advance.
Please Login or Register to view this content.
Bookmarks