rowfield

  1. S

    VBA PivotTable RowField CurrentPage Filter and PageField CurrentPage Filter

    I have two PivotFields. One will be a PageField while the other is a RowField. My macro will switch them, while also grabbing values from the top of the page and using these values as the CurrentPage for each Field. I get an error when running the macro that says Error 1004: Unable to Get the...
    • Stein
    • Thread
    • currentpage pagefield pivottable rowfield vba
    • Replies: 0
    • Forum: Excel Questions
  2. J

    PivotTable RowFields Arrays Question

    Can someone tell me why the following to attempts to assign RowFields to a PivotTable (PT) are not equivalent? Or better yet, why can I not use an Array Variable to assign RowFields? Dim PT As PivotTable ... Dim HeaderArray() As String ... PT.AddFields RowFields:=HeaderArray PT.AddFields...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top