change Sheet1's name

[emilt_milut]

I'm trying to change Sheet1's name to the B2999 cell content.
I use the following statement:
Sheets ("Sheet1") Name ="ActiveCell.FormulaR1C1, CELL (" "content," R [2993] C[-17]) "".
What is wrong?
Thank you very much for your help.
Leon Traubkatz<o></o>

 

[Fluff]

How about

Sheets("Sheet1").Name = Sheets("Sheet1").Range("B2999").Value

 

[My Aswer Is This]

Try this:

Sub Sheet_Name()
Sheets("Sheet1").Name = Range("B2999").Value
End Sub

 

[emilt_milut]

Thank you very, very, very much. It works!!!
Leon Traubkatz

 

[Fluff]

Glad we could help & thanks for the feedback

 

[My Aswer Is This]

Glad we were able to help you.
Come back here to Mr. Excel next time you need additional assistance.