If the sheet you wish to name is active then use....
ActiveSheet.Name = Range("C1")

If it is called Sheet1 then use....
Worksheets("Sheet1").Name = Range("C1")

If the active sheet is not providing the value from range C1 then use....
Worksheets("Shhet1").Name = Worksheets("Sheet").Range("C1")

NOTE: If C1 is empty you will get an error.


--
Cheers
Nigel



"Nigel Bennett" wrote in message
...
Is there a way for a Worksheet name to be changed the the
value in a particular cell

I would like the value for example in cell C1 to be the
worksheet name


Thanks

Nigel