hi ozcank...

try this:

imagine sheets(1) as the first sheet of the workbook:
Sheets(1).Name = Cells(1, 1)

sheet(1) have the value of first row,column

Miguel

"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