Select Method of Range Class Failed

[lalaluye]

Hi,

I'm trying to write a code such that when the user presses the button GRAPH, it graphs the data in the file for each column
Capture.PNG

I run into a debug error on this line:

Please Login or Register  to view this content.

Full code:

Please Login or Register  to view this content.

It's weird because I wrote this code before and it worked before. Now I'm trying to modify it responds through a button on a form so that it is more user friendly.
This is my old code that worked. I can't seem to see the difference.

Please Login or Register  to view this content.

DataProcessing_Tool.xlsm

[Norie]

Do you need to select the range?

[lalaluye]

I need to select a range to graph it right? When I edit the range out, it gives me an empty graph.

[Norie]

You specify the same range as the source for the chart a couple of lines down, here.

Please Login or Register  to view this content.

I would have thought that was all you would need.

[lalaluye]

I tried removing that range select line, but it gave me an empty chart.

[lalaluye]

You are right. We don't need to select the range.. I removed it from my old code and it still graphs.
However, I am still not getting any graphs for my modified code to fit the userform. I get a debug error at strChrt = Trim(Replace(ActiveChart.Name, ActiveSheet.Name, "")) indicating "The item with the specified name not found"

[Norie]

Any chance you could upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[lalaluye]

Sure! I attached it to the first post. It is still work in progress. Here is the sample data I need to graph (individually by column)DC Merged.xlsx

[Norie]

I think I know what the problem is.

When you refer to a range in a worksheet module without specifying explicity the sheet and workbook the range is from VBA uses the range on the worksheet who's module the code is in.

In this case the code is looking at Sheet1 in DataProcessing_Tool.xlsm, not the active sheet of DC Merged.xls.

Give this a try.

Please Login or Register  to view this content.

[lalaluye]

I get a debug error here: .Shapes(strChrt).Left = nLesft
The item with specified name wasn't found.

I do see a graph now. Thank you very much. The next part (trying to place it in specified location) is a bit bugged.

[lalaluye]

It worked, then it doesn't work again when I pressed the GRAPH button... :S

[Norie]

You mean when you run it manually it works but it doesn't work when you click the GRAPH button?

Strange, it works both ways for me with the sample file.