Need Help: VBA Run Time Error 91

Hello, I am developing a spreadsheet that will take the values obtained from a macro and create graphs out of them. I believe my coding is sound, but when I click on the button that should generate the graph, the error mesage: "Run Time Error 91" occurs meaning that the object variable isn't set, which I do not know what that means or how to remedy it. The code is listed below. Thank you for your help in advance.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Which workbook and which module have you inserted this code in? Are you working with a particular workbook that has a sheet "Results" or could it be one of many?

I am asking because I wonder why the code refers to ActiveWorkbook, instead of the workbook containing the code, or a particular workbook.

Which line of code causes the error? You will see if you select "Debug" when the error pops up.

Maybe:

Please Login or Register  to view this content.

Originally Posted by 6StringJazzer

There is no active AutoFilter in sheet Results. Adding the following line as the first line of code may resolve it.

Please Login or Register  to view this content.

I have inserted this line of code and it seems to have remedied the previous problem, thank you very much. However, a problem occurs in the .Apply line : Runtime Error 1004: which says that you can not move a pivot table report. I will put the code below:

Please Login or Register  to view this content.

I have also used the code provided by xladept and the same error presented in this post occurred on the same line. Thanks again guys!

Hi Brandon,

You're welcome and thanks for the rep!

BTW - is it a Pivot Table Report?