run time error 9 : subscript out of range

This program is supposed to take the value in two combo boxes and use them to populate pivot charts that are in other spreadsheets. So a user would select PS and AMI on sheet one (s) and it would change the pivot table on s1-s9 to look up those chosen fields. I keep getting a subscript out of range error, and I'm not sure if my pivottable.pivotlayout method is correct, but when I recorded a macro (in the very bottom) using activesheet, it worked. How can I fix this?

The error occurs at the first large text, the second large text is the recorded macro.

Please Login or Register  to view this content.

I have checked that, its not the case. I copied the names of the tabs directly from the sheet tabs, and then also copied the workbook name directly. No fix.

i'm sure this is about to make me look like an idiot

all the sheets are in the same file, do I need to reference the workbook?

I'm an idiot, right?

I should also say this is only the third code I have made.

All the sheets are in the leading indicators fw33.xls workbook. But I want this all to run in the background so that if the button is pressed, you dont see every sheet pop up as it updates.

do I say this:

Please Login or Register  to view this content.

Then what should the beginning of this line look like?

Please Login or Register  to view this content.

okay, I'm not quite sure what you mean. This worked on a previous macro I wrote, so I don't quite understand the difference

do i declare

Please Login or Register  to view this content.

the opportunity created sheet is just a pivot chart, I got this file from my boss. I guess that would just make it a chart sheet.

does that have a different name for the code?

Please Login or Register  to view this content.

so on the next lines, should I change ws1 to .charts(cht)?
should it be cht.pivottables ... ? I'm getting an object doesnt support property or method on the pivot tables line.

Please Login or Register  to view this content.

This code is causing me a lot of grief.

Unable to set the _Default property of the PivotItem class

Please Login or Register  to view this content.

I appreciate everyones help, but do realize, I'm new to coding so I don't really understand all the advice that is being given.

Okay, instead of trying to update the chart, can I not just update the sheet that has the pivot table instead? So I set Combobox 1 and 2 on the first sheet, then have the pivot table in "sheet1" change. Here is the recorded macro

Please Login or Register  to view this content.

and here is what I tried:

Please Login or Register  to view this content.

I get run time error 1004: unable to set the default property of the pivotitem class at the bolded line.

I also tried this code, I found searching the net; I get a run time error 424 : object required, then the highlighted field says "method range of objects '_worksheet failed when hovered over it.

To be honest I'd like to use something simple like the code I put in the previous post above this.

Please Login or Register  to view this content.

actually i think i fixed it guys, sorry for all the posts