Graphing data from Sheet2 & placing graph on Sheet1 error

Hi All,

I am trying to plot a graph.
I have one workbook with two worksheets, they are Sheet1 and Sheet2.

There are lots of rows of data in both Sheets, I am plotting graphs from the data in Sheet1 and placing them on sheet1 near the data that I am using. Then for one of the graphs I am accessing data from Sheet2, but placing this graph on Sheet1 to keep all of the graphs together for display. Here’s where I have the problem, when I was testing the code on a certain Workbook, it all worked fine, but when I opened up another Workbook, with only two worksheets – Sheet1 and Sheet2, it appears to be exactly the same as my tests Workbook it come up with the “Run-time error 9” – Subscript out of range.

And stops at this line

Please Login or Register  to view this content.

Here is the is cut down code

Please Login or Register  to view this content.

Hopefully someone can see what I cannot or offer some advice.

Thanks
Nat

Hi, you have probably checked the exact names of the sheets in the new workbook so, have you tried to activate the workbook on the start of the code? Or try defining a workbook variable to be used for the current workbook and use it instead of the "ThisWorkbook" parameter?

Thanks harprik, I tried this and still the problem exists.

Just to clarify more the code I am using is in an xla file that opens up every time I open excel. I open the excel file with my data in Sheet1 and Sheet2, Sheet1 is the active sheet and when I run the code it always has an error accessing Sheet2. Could it be related to this?

Thanks
Nat