software

I am trying to set the name of a Sheet to a Cell within that sheet. Example
its current name is quot;Sheet1quot;. I need the sheet name to change to a value in
a Cell. Is this possible - can anyone help.
Thank you!'/========================================/
Sub ChangeSheetName()
Application.ActiveSheet.Name = ActiveCell.Value
End Sub
'/========================================/

OR

'/========================================/
Sub ChangeSheetName()
Application.ActiveSheet.Name = Range(quot;C2quot;).Value
End Sub
'/========================================/HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;kendallquot; wrote:

gt; I am trying to set the name of a Sheet to a Cell within that sheet. Example
gt; its current name is quot;Sheet1quot;. I need the sheet name to change to a value in
gt; a Cell. Is this possible - can anyone help.
gt; Thank you!
gt;