In Excel i want to rename the worksheet tab using a VB macro. I want it to copy a cell on the worksheet and use it as the worksheet name. It needs to be variable because i want to copy the worksheet, increment the cell value by one, and have the new worksheet named the new cell value.
Here is the code:

ActiveSheet.Copy After:=ActiveSheet

ActiveSheet.Previous.Select
Range("j3").Copy
ActiveSheet.Next.Select
Range("j3").PasteSpecial xlPasteValues
Range("j3").Value = Range("j3").Value + 1
ActiveSheet.Name = Range("j3").Value

It is the last line that is giving me trouble.

Thanks for any help.

ActiveSheet.Name = Format(Range("j3").Value, "#")

It worked perfectly, I did change the format to mm-dd-yy.

Thank you egkenny!