Hello community!

Thanks for having an Excel help forum! I am a very new user to Excel. Everything that I know about it, is self taught. I have had a half semester's of C++ training eight years ago, so I can generally read through a little of the vba syntax and understand its semantics. Basically, I get the 'general' concept of what is going on, but I have a rough time programming.

I just discovered the dynamics of this 'macro'. And I am having so much fun with it! I'm rather shocked that I haven't played with and figured Excel out sooner!

Here is my issue. I have a macro that I recorded and I can only use it when the sheet I am viewing is called "Sheet1". If I was to run the macro anytime after that, Excel has a brain fart. I believe this line of code is the thorn in my side:

Sheets("Sheet1").Select

Is there a way that I could change the code and reference the current sheet the macro is running on? Possibly something like this:

Sheets(The_Current_Sheet_The_Macro_Is_On).Select

My purpose of this Macro is that I going to run it on any sheet whose name may be "Sheet" + x. Or I may even get really fancy and name my sheet something meaningful. Either way, I need the code to reference the active sheet. I just don't know how to do that... And Google isn't being helpful.

Thanks for your time,

Mike


P.S. If there are any (free) VBA + Excel resources I can use, will you please link it?
P.S.S. This is just an annoyance issue: How do I get the Macro to save the location I place a graph on the worksheet? Right now, it sticks both graphs on top of each other, and I have to move it.