VBA combining Select & Name = statements

[Pinaceous]

Hi All,

I'm working with:

    Sheets("First SEP REPORT").Select
    Sheets("First SEP REPORT").Name = "Second SEP REPORT"

Where I'm trying to select the worksheet then change its name. I have 24 tabs where this code is providing a sample of the macro I'm using above.



Does anyone know how to combine these particular VBA statements?


I've tried experimenting on this method:

Application.Goto Worksheets("First SEP REPORT").Name = "Second SEP REPORT", True

But this is not working well for me, when I am combining these steps in this way.

Any ideas??

Thanks,
Pinaceous

 

[Norie]

You don't need to select a sheet to change it's name so this on its own should do.

    Sheets("First SEP REPORT").Name = "Second SEP REPORT"

 

[Pinaceous]

Oh okay, that's great! Thanks again

 

[Pinaceous]

I'm actually getting a

VBA Run-time error '1004':

Application-defined or object-defined error

I cannot seem to make this work w/o first individually selecting the specific sheet.

Any suggestions?

 

[Pinaceous]

Wait, wait, wait, it works, my apologizes! I had to unlock the workbook!