Updating Tab Names to match a Cell

**leigh3980** · 08-01-2019, 02:38 PM

Hi all,
I am looking for either a formula to place in A1 that will update the tab name to match the contents of B4, or a macro that will do the same but will update the tab names of all sheets in my workbook.

Many thanks for all the help as always.

Leigh

**Arkadi** · 08-01-2019, 02:46 PM

Hi Leigh, I don't believe any formula can do that. Are you saying you want the each sheet renamed based on the contents of cell B4 in that sheet? If so:

Sub renamer()

Dim ws As Worksheet

For Each ws In ThisWorkbook.Worksheets
    If ws.Range("B4").Value <> vbNullString Then ws.Name = ws.Range("B4").Value
Next ws

End Sub

I didn't add anything to deal with B4 contents that are longer that the max allowed for a tab name...

**leigh3980** · 08-01-2019, 02:54 PM

Arkadi,
Many thanks works perfectly!!!!

**Arkadi** · 08-06-2019, 08:34 AM

Glad I could help Leigh

Thanks for the feedback, the rep, and marking the thread as solved!

Updating Tab Names to match a Cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Updating Tab Names to match a Cell

Re: Updating Tab Names to match a Cell

Re: Updating Tab Names to match a Cell

Re: Updating Tab Names to match a Cell

Thread Information

Users Browsing this Thread

Similar Threads

Using if function to match cell names in different column

Match names and copy another cell

where names match copy cell from one sheet to another

[SOLVED] Copy cell value from another Tab if names match up

How to Insert pictures with fie names that match active cell value (vba)?

[SOLVED] Match names on one spreadsheet to the names on another then copy contents of another cell

Compare and match names and extract a cell content

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions