I am coding in excel 2007 vba to create a pivot table based on data on the tab. Although my code is more complicated than the code below, I believe I have narrowed my problem down to the fact that whenever I attempt to filter a single character value I encounter a Run-time error '1004': Unable to get the PivotItems property of the PivotField class.
As an example I ran the following code which worked:
'this works![]()
Please Login or Register to view this content.
However, when filtering for "J" I encounter the run-time error '1004':
'this does not work![]()
Please Login or Register to view this content.
Bookmarks