| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using variable in value1 of PivotFilters.Add
Hi,
I am new to Macros and VBA. Trying to use a variable for value1 of pivotfilters.add but it isn't working. getting runtime error 1004. Dim a As Variant filtname = InputBox("Which data do you want", "Data input") ActiveSheet.PivotTables("PivotTable1").PivotFields ("Release cause"). _ PivotFilters.Add Type:=xlCaptionContains, Value1:=filtname Thanks. Aamer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't change pivotfilter value1 parameter in code | Excel Programming | |||
| Get errors when updating PivotFilters | Excel Programming | |||
| PivotFilters in pivottable | Excel Programming | |||
| Error Using the PivotFilters function | Excel Programming | |||
| scatter plots and "label" as ("X" value1, value2) | Charts and Charting in Excel | |||
Threaded Mode
