Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Using the PivotFilters function
hi to all!
I'm just new in pivottable programming in excel. I can't get to work the PivotFilters function, the statement is written as: shtWorksheet.PivotTables(1).PivotFields(23).PivotF ilters.Add Type: =xlValueIsBetween, Value1:="101" running this statement causes me an error saying: Runtime error 1004, Application-define or Object defined error. Thanks in advance for replies. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Using the PivotFilters function
The worksheet, pivot table or pivot field is missing?
-- Regards, Nigel "jmlozares" <u44951@uwe wrote in message news:87756b22bab9b@uwe... hi to all! I'm just new in pivottable programming in excel. I can't get to work the PivotFilters function, the statement is written as: shtWorksheet.PivotTables(1).PivotFields(23).PivotF ilters.Add Type: =xlValueIsBetween, Value1:="101" running this statement causes me an error saying: Runtime error 1004, Application-define or Object defined error. Thanks in advance for replies. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Using the PivotFilters function
Thanks nigel!
I was able to solve my problem. I've used the Visible property of the PivotItem object instead. Regards, Jan Nigel wrote: The worksheet, pivot table or pivot field is missing? hi to all! [quoted text clipped - 9 lines] Thanks in advance for replies. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200807/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Error? | Excel Worksheet Functions | |||
Function Error | Excel Discussion (Misc queries) | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
If error function | Excel Worksheet Functions | |||
Function Error | Excel Programming |