activesheet.pivottables

  1. S

    VBA: Error with adding datafields to a pivot table

    Hi guys, I have some code that does its job in adding datafields to a pivot table. I linked it with a form control button: Sub PDA1P() ' ' PDA1P Macro ' Adds all 1P PDA columns into values of PT ' ' Keyboard Shortcut: Ctrl+Shift+P ' ActiveSheet.PivotTables("SpendTable").AddDataField...
  2. O

    Macro's errors

    Is it possible to create a Macro that will sort some data, then used this sorted Data to create a Pivot table, then using the results of the pivot table, pasting the results as values then creating another pivot table? All this is done on the same sheet. I have tried to create this macro and...
  3. M

    Recorded Macro

    Hi I've recorded the following Macro in a workbook called SCSGroupageT which is obviously referenced in the code. How do i need to amend the code so that it will run in any workbook? Thanks Sub Testvba() ' ' Testvba Macro ' ' Range("A1:I2656").Select Range("C4").Activate...
  4. 0

    VBA Pivot Table

    Hello I have made a pivot table with the code below but when i add a new date "rows" the new data didn't appear in the pivot table how to Fix it ?? Range("A5:S1000").Select ActiveWorkbook.Worksheets("PIVOT1").PivotTables("PivotTable2").PivotCache. _ CreatePivotTable...
  5. H

    Dynamic selection Pivot

    Hi, I am trying to Run the dynamic selection Pivot tab,its reflecting a error as Invalid procedure call or argument I have bolded the code lines which reflect error .I am unable to figure out what went wrong. Sub Macro2() ' ' Macro2 Macro ' ' Range("N3").Select...

Watch MrExcel Video

This Week's Hot Topics

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
Top