![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
![]()
Guessed, thankyou for the section of code, it works perfectly when appended to the original section of code I had put together.
Macropod, thanks again for you help. My apologies if my approach is frustrating. Unfortunately I don't know enough about what I am doing to tackle everything in one go so had resigned myself to adding in functionality in sections as I learn what I am doing. there is an issue at this line when I run the code Code:
ThisWorkbook.Worksheets("InspectionPivot").PivotTables("InspectionPivot").TableRange2.Copy Thanks Thom |
#2
|
||||
|
||||
![]() Quote:
Code:
Dim tbl As PivotTable ... Set tbl = ThisWorkbook.Worksheets("InspectionPivot").PivotTables("InspectionPivot") ... tbl.TableRange2.Copy
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
epid011 | Word Tables | 2 | 05-15-2017 05:21 PM |
![]() |
Dudlee | Word VBA | 1 | 09-20-2016 04:58 PM |
![]() |
jc491 | Word VBA | 8 | 09-30-2015 06:10 AM |
![]() |
RobsterCraw | Word VBA | 16 | 11-20-2012 03:25 PM |
![]() |
tinfanide | Word VBA | 3 | 04-27-2012 09:48 AM |