want to name a tab after a cell value. Ex: Ja

September 17, 2011 at 17:52:28
Specs: Windows XP
what formula names a tab after a cell value?

See More: want to name a tab after a cell value. Ex: Ja

Report •

#1
September 17, 2011 at 18:46:16
There is no formula to name a tab from a value in a cell. You need to use VBA (a macro) to do it, and there are a few factors that need to be considered:

The code will depend on whether you want to name just one sheet based the cell contents or multiple sheets. It will also depend on whether you want it to run automatically or run when the user chooses.

You'll have to deal with the possibility of invalid sheet names, such as duplicates or names with characters that are not allowed to be used in a sheet name.

Give us some more details and we'll see what we can suggest.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question