VBA to reposition pivot table performs incorrect task

**adamstarr12** · 07-16-2015, 02:42 PM

Hello,

I've written some code here to reposition one of two pivot tables on a page:

When the code is running the variable "LastRow_PT1" has a valid value.. but when this code executes it moves the second pivot table to another sheet..

Please Login or Register  to view this content.

Thank you for your help!

Adam

**Bernie Deitrick** · 07-16-2015, 03:31 PM

To keep it on the same sheet, use the same sheet in the location

Please Login or Register  to view this content.

**adamstarr12** · 07-16-2015, 04:47 PM

The variable LastRow_PT1 is adjusted earlier in the code.. With the additional offset it still moves the second pivot to another tab..

**Bernie Deitrick** · 07-16-2015, 04:56 PM

Oops - sorry, forgot that location takes a string:

Please Login or Register  to view this content.

**adamstarr12** · 07-16-2015, 06:41 PM

Fantastic Bernie. Thank you!

Adam

VBA to reposition pivot table performs incorrect task

LinkBack

Thread Tools

Rate This Thread

Display

VBA to reposition pivot table performs incorrect task

Re: VBA to reposition pivot table performs incorrect task

Re: VBA to reposition pivot table performs incorrect task

Re: VBA to reposition pivot table performs incorrect task

Re: VBA to reposition pivot table performs incorrect task

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Pivot Table that performs a distinct count in excel 2013

[SOLVED] Incorrect data in Pivot table

Pivot table sum value incorrect

Pivot table row total INCORRECT

how to reposition a data table in chart

[SOLVED] Incorrect totals in Pivot Table

[SOLVED] Pivot Table through Scheduled Task

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions