How to rename an excel worksheet

[SkyHigh]

Hi Folks
I am trying to rename an excel worksheet and get this runtime error '438' "Object doesn't support this property or method "

ExcelSheet("week").Name = "week" & vCurrWeekNumber

Is there another way I can use to do rename a worksheet.

Thanks much !
Brenda

 

[fiep]

Have you tried this?

dim strName as string
strName = "week" & vCurrWeekNumber
ExcelSheet("week").Select
Sheets("week").Name = strName

W.

 

[TonyJollans]

Hi SkyHigh,

What is [purple]ExcelSheet[/purple]?

If it is your sheet object, then you probably want to use just [blue]ExcelSheet.Name[/blue].

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.