Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating the name of a worksheet in a cell
Hi...Happy Christmas
I've written a custom function to provide the worksheet name in a cell... Function sht_name() sht_name = ActiveSheet.Name End Function I've copied this to other sheets, but it doesn't appear to update for the new sheet name even when I press F9 Really I want the sheet name to be there irrespective of whether the sheet is the active one or not...it'll save my typing them individually for 60 sheets.... Your help is appreciated as always....Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem: vba code for creating a button to save worksheet as Cell | Excel Programming | |||
Creating Worksheet With Cell name Once a Cell Activated. | Excel Programming | |||
Creating or going to a worksheet | Excel Programming | |||
Creating a worksheet with values based on a control cell | Excel Programming | |||
Creating a Worksheet in VBA | Excel Programming |