Automatic naming of Worksheets

[Bodger]

Does anyone know of a formula that will automatically name a worksheet for me?
i.e. If cell "A1" has the text "England" in it, to then name the worksheet "England

[jason.b75]

That can't be done with a formula, only with vba, if that is permissible.

[lilsnoop]

Bodger-if you open your visual basic editor (i.e. right click on the worksheet tab in question and then click on "view code", etc.) you could paste the following code in the worksheet window:

Please Login or Register  to view this content.

So whatever you have in Cell A1 will be what the tab sheet ends up being titled. You will have to refresh the worksheet (F9) to see the result. Hope it helps.

[Bodger]

Brilliant lilsnoop - Many, many thanks

[lilsnoop]

Glad it worked for you!