pivot update range of values

Shiro26

Board Regular
Joined
Oct 2, 2015
Messages
82
Hello

I have a pivot that I call "pvt" and a field in which I paste my criteria and by clicking on a button it refreshes the pivot for the specific ID.
However, this is possible for the IDs one by one.
How could I modify the code in order to take more than one value, lets say in a named range in order to copy paste a set of ID?

Code:
Sub pvtRecRDupdate_click()
Dim wbk As Workbook
Dim wspvt As Worksheet
Dim SnapID As String, SnapPT1 As String
Set wbk = ThisWorkbook
Set wspvt = wbk.ActiveSheet
Application.ScreenUpdating = False
SnapID = wspvt.Cells(5, 1).Value
SnapPT1 = "pvt"
    With wspvt.PivotTables(SnapPT1).PivotFields("ID")
            .ClearAllFilters
            .PivotFilters.Add Type:=xlCaptionEquals, Value1:=SnapID
    End With
Application.ScreenUpdating = True
End Sub

Thank you in advance for your help

Kind Regards,

Shiro
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,123,158
Messages
5,600,052
Members
414,357
Latest member
Gemma_R

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