Sheet Names

[Nigel Bennett]

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

 

[Binzelli]

Nigel,

Try:

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

Good luck