dealing with multiple named worksheets with one macro

[Ray Morton]

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.

 

[Vasant Nanavati]

Hi Ray:

ActiveSheet

Regards,

Vasant.

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.

 

[Ray Morton]

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"

 

[Tom Ogilvy]

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

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"