compile error after editing VBA so graphs are independent of the worksheet

[kjiratsiekoedel]

I am doing some research and I created a lot of worksheets with the same data-format. From every sheet I want to create the same type of graph, so a macro could be very useful.

First I recorded a macro. The worked fine, but it could only be used by only one worksheet. Every time I used the macro it returned to the original worksheet where I created the macro.

With some searching I found out how to change the code so that the macro could be used for the active sheet.

But now I get stuck with the following error: "compile error: invalid qualification" (translated from Dutch).
With error tracking I get stuck at the first line "Sub grafiek()"


I tried to solve this error, but I don't understand the problem. Can someone help me solving?

---------------------------

This is my code:

Please Login or Register  to view this content.

[romperstomper]

You would need to replace all instances of sSheetName.Name with just sSheetName since it is a String not an object. (there may be other errors, but that one jumped out at me!)

[kjiratsiekoedel]

That helped!

Now there is a second error: I want that the graph is inserted in the active sheet. The error in bold

Please Login or Register  to view this content.

[romperstomper]

You would need:

Please Login or Register  to view this content.

[kjiratsiekoedel]

Thanks. I know I had a newbe question, but I am very happy you could help me so quickly!