Worksheets("Sheet1").name=Range("A1").Value

You can omit the ".Value"

"ozcank" wrote:


Hi All

Is there a way of giving the worksheet name the same as the value of a
cell?

Thanks

Oz


--
ozcank


------------------------------------------------------------------------
ozcank's Profile: http://www.excelforum.com/member.php...fo&userid=5328
View this thread: http://www.excelforum.com/showthread...hreadid=382406