No, I tried it but it did not work.


"GB" wrote in message ...
Does this work?

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

GB


"Jay Dean" wrote in message
om...
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