I want one macro to create a chart over a set the same amount of cells no matter what the worksheet or workbook is named. Is there some "activeworksheet" command that I can use in my code that will work no matter what the name is? So far the code is getting hung up on setting the source data with a specific worksheet name. any suggestion would be greatly appreiciated.

Hi Ray:

ActiveSheet

Regards,

Vasant.

"Ray Morton" wrote in message
...
I want one macro to create a chart over a set the same amount of cells no
matter what the worksheet or workbook is named. Is there some
"activeworksheet" command that I can use in my code that will work no matter
what the name is? So far the code is getting hung up on setting the source
data with a specific worksheet name. any suggestion would be greatly
appreiciated.

If I wanted to change this particular module:
Sheets("tanks006").select
Sheets("tanks006").name="tanks"

How would I go about doing this? I tried using activesheet and it didn't work. I want this name to be able to change to anything and still be able to change what ever it is to "Tanks"

If you want to select a particular sheet, you need to specify what the sheet
name is or some other way to identify it. ActiveSheet pertains to the
currently visible sheet.


Activesheet.Name = "tanks"

will name the activesheet tanks.

But the challenge is how to identify that it is tanks006 that you want to
rename. The question is how you would identify the sheet you want to
rename?

--
Regards,
Tom Ogilvy

Ray Morton wrote in message
...
If I wanted to change this particular module:
Sheets("tanks006").select
Sheets("tanks006").name="tanks"

How would I go about doing this? I tried using activesheet and it didn't
work. I want this name to be able to change to anything and still be able to
change what ever it is to "Tanks"