MACRO TO RENAME SHEET !

Jay Dean · Oct 16, 2003

I have 2 Excel Workbooks -- Book1 and Book2.
I want a code that will rename Sheet1 of Book1 whatever the value in
cell A1 in Sheet2 of Book2 is.

Any assistance would be appreciated. Thanks!

Jay Dean

Don Guillett · Oct 16, 2003

try this
sheets("sheet1").name=workbooks("book1.xls").sheets("sheet2").range("a1")

GB · Oct 16, 2003

Does this work?

Workbooks("Book1").Sheets(1).Name =
Workbooks("Book2").Sheets(2).Range("A1").Value

GB

Jay Dean · Oct 17, 2003

No, I tried it but it did not work.

GB said:
Does this work?

Workbooks("Book1").Sheets(1).Name =
Workbooks("Book2").Sheets(2).Range("A1").Value

GB

GB · Oct 17, 2003

Jay Dean said:
No, I tried it but it did not work.

Ahem - what happened? It works on my machine and Don Guillett posted almost
identical code.

BTW, you said that your spreadsheets are called Book1 and Book2. You may
have meant Book1.xls and Book2.xls. Have you put the correct names in?

GB