![]() |
#1
|
||||
|
||||
![]()
Hi. This code selects the range A5 to AQ50. I would like the code to select only the rows from A5 until the last row of a dynamic pivot table.
Code:
Dim lr As Long Range("A5:AQ5" & lr).Select Selection.Copy Thank you. |
#2
|
||||
|
||||
![]()
We need to know a bit more about the pivot table.
Best attach a (mockup of) the workbook with what you want selected highlighted, also a bit of info on how dynamic the pivot will be (row numbers, column numbers, compact view perhaps etc.) |
#3
|
||||
|
||||
![]()
Here is a mock up data.
|
#4
|
||||
|
||||
![]()
In the attached a macro:
Code:
Sub test() Set PT = Sheets("Sum").PivotTables(1) PT.TableRange1.Copy Sheets("SumA").Range("F4").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True End Sub |
#5
|
||||
|
||||
![]()
It's perfect p45Cal
I did not know that the field lists in the Values section could also be the field lists in the Rows section. I thought that a field should only be placed in either Filter, Row or Column. Thank you.. |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Select entire text and then de-select certain Headings? | tq94 | Word | 3 | 02-26-2022 03:47 AM |
![]() |
yacov | Word | 2 | 10-25-2020 02:53 AM |
![]() |
ArtKilp | Word VBA | 2 | 06-15-2020 06:44 PM |
![]() |
cosmicyes | Excel Programming | 1 | 07-09-2018 02:47 AM |
![]() |
aymanharake | Excel Programming | 3 | 02-18-2017 04:09 PM |