I have a pivot table I want to filter based upon the value supplied by the user. I tried to create a macro to do this, but keep getting a "1004" error which states 'application-defined or object-defined error'. When I look at the variable, it is holding the value, but it can't be used for some...