I'm trying to create a pivot table on a new sheet with dynamic sheet names/ranges and I keep getting error "Invalid procedure call or argument" error. My code is below:
Just for comparison sake, code when copied straight from the from macro:![]()
Please Login or Register to view this content.
All I've done is replace the static ranges with dynamic ones. Why isn't this working? Any help is appreciated!![]()
Please Login or Register to view this content.
Bookmarks