Good day,
I'm trying to get the range to create a pivot table. The Column amounts can differ each month and the rows. My code is not working at the marked section (Red) and I believe the line after that won't either to create the Pivot table Range. Is there a better way to do it or to fix this code please?
Please Login or Register to view this content.
Last edited by Simone Fick; 09-10-2017 at 05:25 PM. Reason: Solved
Hi Simone,
Change the "xlToRight" to "xlToLeft" in your code and see if that then works.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi MarvinP,
Unfortunately, it doesn't work. It still gives me an error on the same line. " Run time error '1004': Application defined or object defined error"
Try
PvtRange = Worksheets("Active Instances").Range(Cells(RowsCount, ColCount))
It still gives the same error
I solved the problem with the following code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks