U
uclawarren
I have a pivot table, and within the row field, I would be able to writ
a macro to move a certain row to the bottom, regardless of the number o
rows. Currently, if I move the row to the bottom while recording th
macro, it will list the position number, such as
ActiveSheet.PivotTables("PivotTable2").PivotFields("Carrier").PivotItems
_
"Other").Position = 8
I found that I will not get the result I want unless there are exactl
8 items in the row section. Does anyone know if there is a way to mak
sure that it moves to the "Last" position?
Thank
a macro to move a certain row to the bottom, regardless of the number o
rows. Currently, if I move the row to the bottom while recording th
macro, it will list the position number, such as
ActiveSheet.PivotTables("PivotTable2").PivotFields("Carrier").PivotItems
_
"Other").Position = 8
I found that I will not get the result I want unless there are exactl
8 items in the row section. Does anyone know if there is a way to mak
sure that it moves to the "Last" position?
Thank