[Anwsered] Automatically Insert Sheet Name into a Cell

Automatically Insert Sheet Name into a Cell

I would like to insert into a cell the name of the worksheet it belongs to.

I found this on the web:

Function WorkSheetName() As String
ActiveSheet.Activate
WorkSheetName = ActiveSheet.Name
End Function

I pressed Alt-F11 to get the VBA editor and placed this exact code above into it.

Into the cell where I want the sheet name to go I put in "=worksheetname()" but I get "#NAME?" instead of the sheet name.

Suggestions?

JIM

Keys to the Problem Automatically Insert Sheet why have my tiles gone black and white? i dont know how to change back to colour. Help :( Name into a Cell

Unfortunately the file name constantly changes.
 It is renamed with a date reference every time it is updated.



The formula I gave you is like any other and will recalculate whenever Excel does so if you change the worksheet name the formula I gave you will update to show that new name.
 
IMO the UDF approach is not a Keyboard keys typing numbers instead of text good idea because it returns the name of the activesheeet so if you call the udf from 2 different sheets the formula will be incorrect on the sheet you can't see.
More importantly, changing worksheets doesn't make Excel calculate
so the formula will always display the name of the sheet that was active the last time Excel calculated.
 
That UDF doesn't calculate when Excel does because it isn't volatile.
To make it volatile windows 8 cannot share from the dektop? you must add
 
Application.volatile
 
as the first line but this doesn't cure the potential problem noted above.

Click here to download format text colour via a formula the registry repair application

Another Safe way to Repair the problem: Automatically Insert Sheet Name into a Cell:

Click here to download the registry repair application .

How to Fix Automatically Insert Sheet Name into a Cell with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll the System Protection tab in System Properties cannot find disk drives so it cannot create a restore point. downloading, junk file cleaning and print spooler error repair.