View Full Version : Solved: How do I Automatic Sheet name from cell value
Erays
09-21-2006, 06:21 PM
I would like to put is a formula that willname the sheet from cell Value can anyone help
Erdin? E. Ka
09-21-2006, 07:37 PM
For example:
Sheet1, A1's value is "The Name Of The Sheet"
You can write the codes below to Sheet1's coding page;
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveSheet.Name <> [A1] Then ActiveSheet.Name = [A1]
End Sub
This example is about writing a formula for name of the sheet into a cell
=RIGHT(CELL("FILENAME";A1);LEN(CELL("FILENAME";A1))-FIND("]";CELL("FILENAME";A1);1))
Erays
09-22-2006, 07:57 PM
Thank you works like a charm
Erdin? E. Ka
09-22-2006, 10:12 PM
Happy to help. :)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.