#1
|
|||
|
|||
Pivot Fields get Error 1004
Hi. I recorded a macro to create a pivot table. When I try to run the macro, I get the 1004 error (Application defined or object defined error) for these three commands. Any insight on how I can correct this?
.DisplayMemberPropertyTooltips = False .AllowMultipleFilters = True .CalculatedMembersInFilters = False Thanks! Mike. |
#2
|
||||
|
||||
Those three lines need to be preceded by a line that starts with "With ..." and followed by a line that says "End With"
The .DisplayMemberPropertyTooltips is saying it is a member of that thing that follows the With statement. Does your code include that With statement (and you haven't posted it) or is that missing in your code too?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error | PLSBRYDOBOY | Excel Programming | 0 | 08-30-2019 12:17 PM |
Error 1004 on EnvelopeVisable | mamies | Excel Programming | 4 | 03-01-2017 05:14 PM |
Run Time Error '1004' | galkej | Excel | 0 | 02-03-2014 06:39 AM |
Run time error 1004 | yonasan | Excel Programming | 3 | 06-12-2012 11:08 PM |
runtime error 1004 | gbaker | Excel Programming | 11 | 06-06-2012 05:23 AM |