Nigel,

Try:

Activesheet.name = Range("C2").Text

Good luck


"Nigel Bennett" wrote in message
...
I want to Name a sheet programatically when it becomes
active, I have the sheet name in Cell C2 and want to
rename the sheet using that name

Thanks

Nigel